formula help???

[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 (e-mail address removed) TIA.......

 

[Anders S]

Phil,

Try

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

Adjust the ranges to suit.

HTH
Anders Silvén

 

[The Red Cardinal]

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 (e-mail address removed) TIA.......

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.

 

[The Red Cardinal]

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.

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