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
Phil wrote:
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 TIA.......