formula help
 

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

formula help
 

Phil

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

or you can check the whole column:

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

Regards

Trevor


"Phil" wrote in message
news:EoJcb.17426$gv5.5308@fed1read05...
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.......

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