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

=SUMIF(A1:A6,"=",B1:B6)

or you can check the whole column:

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

Regards

Trevor
 
It depends on what you mean by "blank". If they actually have nothing in
them (empty blanks), then Trevor Shuttleworth's formula will work (for
the range A1:B6). If they might have the empty string (i.e., =""), ',
etc. (string blanks) then you can use

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

Alan Beban
 
Back
Top