Thread: formula help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default formula help

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