| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif(Not blank)
Trying to count cells in the indicated cell that are not blank. This is what
I tried, but it still counts blank cells. =(COUNTIF(AB4,"<""")+COUNTIF(AG4,"<""")+COUNTIF( AL4,"<""")+COUNTIF(AQ4,"<""")) Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif(Not blank)
Just use "<" rather than "<"""
Regards, Fred. "David" wrote in message ... Trying to count cells in the indicated cell that are not blank. This is what I tried, but it still counts blank cells. =(COUNTIF(AB4,"<""")+COUNTIF(AG4,"<""")+COUNTIF( AL4,"<""")+COUNTIF(AQ4,"<""")) Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif(Not blank)
Try this:
=SUMPRODUCT(--(MOD(COLUMN(AB4:AQ4),5)=3),--(AB4:AQ4<"")) "David" wrote: Trying to count cells in the indicated cell that are not blank. This is what I tried, but it still counts blank cells. =(COUNTIF(AB4,"<""")+COUNTIF(AG4,"<""")+COUNTIF( AL4,"<""")+COUNTIF(AQ4,"<""")) Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif(Not blank)
To work, your formula would have to be
=COUNTIF(AB4,"<"&"")+COUNTIF(AG4,"<"&"")+COUNTIF (AL4,"<"&"")+COUNTIF(AQ4,"<"&"") However, as Fred said, you can use the simpler =COUNTIF(AB4,"<")+COUNTIF(AG4,"<")+COUNTIF(AL4," <")+COUNTIF(AQ4,"<") Note that there is no need for parentheses around the whole formula Tyro "David" wrote in message ... Trying to count cells in the indicated cell that are not blank. This is what I tried, but it still counts blank cells. =(COUNTIF(AB4,"<""")+COUNTIF(AG4,"<""")+COUNTIF( AL4,"<""")+COUNTIF(AQ4,"<""")) Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif a corresponding value is not equal to zero or blank | Excel Worksheet Functions | |||
| countif, blank if zero | Excel Worksheet Functions | |||
| COUNTIF & Blank Cells | Excel Discussion (Misc queries) | |||
| How to COUNTIF blank cells? | Excel Worksheet Functions | |||
| Countif not blank | Excel Worksheet Functions | |||
Linear Mode
