formula help???

  • Thread starter Thread starter Phil
  • Start date Start date
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 (e-mail address removed) TIA.......
 
Phil,

Try

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

Adjust the ranges to suit.

HTH
Anders Silvén
 
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 (e-mail address removed) 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.
 
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!)
 
Back
Top