Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Do Not count blank cells
Hi all!! I have been trying to figure out how to NOT have excel count blank cells when it is counting my information that my formulas are telling it to count. This is my current formula (array): =SUMPRODUCT(--(oc!$C$1:$C$1000=435),--(oc!$H$1:$H$2000="approved"),--(oc!$D$1:$D$1000="telemedicine") I have to put a space in each blank cell (which could be a bunch) Thanks Dee -- imjustme ------------------------------------------------------------------------ imjustme's Profile: http://www.excelforum.com/member.php...o&userid=26854 View this thread: http://www.excelforum.com/showthread...hreadid=480665 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of cells | Excel Worksheet Functions | |||
Generating truly blank cells | Excel Worksheet Functions | |||
formula to count cells not blanK | Excel Worksheet Functions | |||
removing blank cells from a column | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) |