| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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....... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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....... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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....... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
