Sum by row classification/type

I have several rows. Each row has amounts and in each row in a column which has a row type in it (i.e. cash, check, etc.). What would the command be that would read the row type in each row and give me a total for only those with a certain type (i.e. All rows marked with the type "cash" would be added up and the sum would only be the total of the cash rows).

Hi!

Look at SUMIF.


So: =SUMIF(B1:B100,C1,D1:D100) will look down column Band addup all of the cells in column D where C1 is equal to the corresponding item in column B.

It's actually simpler to do than to explain!

Alf

So as long as the info in B1 and D1 are the same it will include it in the SUM but if B1 and D1 are different it won't add it to the sum?