I was hoping someone would post this one. I believe in the K.I.S.S.
philosophy, and what could be simpler than your solution? That's why you get
paid the big bucks ! ;)
--
RMC,CPA


"Tom Ogilvy" wrote in message
...
=SUMIF(B:B,"0",A:A)

--
Regards,
Tom Ogilvy




"fl" wrote in message ...
I have two columns of data, Column A and Column B.. I need to sum
Column A if there is a correspondence value in Column B.
Column A Column B
----------- ----------
2 1000
1 3000
5
2 6000
1
7 8000
. .
. .
. .
My formular should add values in Column A: 2 + 1 + 2 + 7 = 12. The
value of 5 and 1 will not be added because there is no value in Column B
correspondently. I know how to do it in Access. I am not familiar with
Excel. Please help.

Thank you very much.