Tuesday, November 16, 2004

Using the SUMIF Function in Excel

I use the SUMIF function a lot of the time, maybe too much if thats possible!

Basically the SUMIF funciton sums a range of data based on the criteria it finds in an adjacent range.

So if you have two columns A & B, A with names in it and B with weekly salaries, then you can use the SUMIF function to fnd the total paid to each individual payee.

=SUMIF($A:$A,"Fred",$B:$B)

Note. The criteria (in this case "Fred") must be spelt exactly the same way as in the lookup range (in this case column A). Otherwise it wont be added, this includes trailing spaces in cell contents.


Posted by: Jethro | 1:18 AM |