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

 

[Trevor Shuttleworth]

Phil

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

or you can check the whole column:

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

Regards

Trevor

 

[Alan Beban]

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