One Way

=SUMPRODUCT((A1:A6)*(ISBLANK(B1:B6)=FALSE))

Only works if nothing is in the column B it theres text in B, the
value in A will be added

Dan E

"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.