Excel If function

Not sure if I am using the correct function but I have a question. I am creating a worksheet to track (manually) banking. In column B, I put in the name of the company, in C i put in the amount of Credit, in D, the Debit amount then E contains the bank balance (almost like a chequing book). Columns F though M contain the company names, then in turn each of them are summed at the bottom. Pretty simple. The question I have is...

If I have the company in column B named XYZ company and they are a grocer, I want to move the contents of the amount in column D over to Column F, easy enough...

=SUM(IF($B$9:$B$103="XYZ",D9,0))

But what if I want to perform the check and put the sum total in for mutiple grocer sites... So, I want to add grocer ABC as well. Using the same logic, I put in this formula, but I get an error.

=SUM(IF($B$9:$B$103="XYZ",D9,0)),(IF($B$9:$B$103="ABC",D9,0)))

Am I using the proper operand? I tried "OR" but got no where as all I got was TRUE and FALSE statements!

thanks,

Swaff -)

Hello

I think u need Array Formula. Could u please upload sample filr?

Sure,

here is the Excel worksheet.

Swaff -)