| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can someone help me with this formula
for columns b and c, if b is blank and c 1, i want the count for column c.
i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
Hi Gary,
Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
thanks norman, almost had it right.<g
-- Gary "Norman Jones" wrote in message ... Hi Gary, Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
=SUMPRODUCT((B3:B33="")*(C3:C331))
worked fine. You had a typo. -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks norman, almost had it right.<g -- Gary "Norman Jones" wrote in message ... Hi Gary, Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
thanks for the clarification. just out of curiosity, is it possible to use
or with sumproduct? something like =SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 )) -- Gary "Tom Ogilvy" wrote in message ... =SUMPRODUCT((B3:B33="")*(C3:C331)) worked fine. You had a typo. -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks norman, almost had it right.<g -- Gary "Norman Jones" wrote in message ... Hi Gary, Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
You can't use OR, you can use addition to simulate it - just like you are
doing with AND for multiplication. =SUMPRODUCT(((B3:B33="")+(B3:B33="R")),--(C3:C331)) -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks for the clarification. just out of curiosity, is it possible to use or with sumproduct? something like =SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 )) -- Gary "Tom Ogilvy" wrote in message ... =SUMPRODUCT((B3:B33="")*(C3:C331)) worked fine. You had a typo. -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks norman, almost had it right.<g -- Gary "Norman Jones" wrote in message ... Hi Gary, Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can someone help me with this formula
thanks for that, tom
-- Gary "Tom Ogilvy" wrote in message ... You can't use OR, you can use addition to simulate it - just like you are doing with AND for multiplication. =SUMPRODUCT(((B3:B33="")+(B3:B33="R")),--(C3:C331)) -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks for the clarification. just out of curiosity, is it possible to use or with sumproduct? something like =SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 )) -- Gary "Tom Ogilvy" wrote in message ... =SUMPRODUCT((B3:B33="")*(C3:C331)) worked fine. You had a typo. -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks norman, almost had it right.<g -- Gary "Norman Jones" wrote in message ... Hi Gary, Try: =SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331)) --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... for columns b and c, if b is blank and c 1, i want the count for column c. i tried these to no avail =COUNT(IF(B3:B33="",C3:C31,C3:C33)) =SUMPRODUCT(B3:B33="")*(C3:C331) -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
