formula help???

P

Phil

I need help in seting up a formula? What I need to do is
have column "A" either a blank or an "X". I need the formula to add up all
the numbers in column "B" That have a blank in column "A" Please Help...
Send formula to [email protected] TIA.......
 
A

Anders S

Phil,

Try

=SUMPRODUCT((A1:A24="")*1,B1:B24)

Adjust the ranges to suit.

HTH
Anders Silvén
 
T

The Red Cardinal

Phil said:
I need help in seting up a formula? What I need to do is
have column "A" either a blank or an "X". I need the formula to add
up all the numbers in column "B" That have a blank in column "A"
Please Help... Send formula to [email protected] TIA.......
Click to expand...


You need to use the SUMIF command:

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

This will add the corresponding value in column B for every row in A which
is blank.
 
T

The Red Cardinal

The said:
You need to use the SUMIF command:

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

This will add the corresponding value in column B for every row in A
which is blank.
Click to expand...


P.S. (Add your own row numbers to the formula obviously!)
 
Top