Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting Problem
Hi everyone, My problem is with the COUNTA funciton. I have a formula, "=IF(COUNTA(K4:Q4)0,1,0)", set up so that if at least one cell has a letter/value, then formula will return a result of 1. The cells, which this equation counts, are also formulas as well. (Ex. =IF('Protocol!$K4="","",'Protoco !$K4)) I want to be able to count the cells that have data, yet not count those cells which have a blank result. Is there anyway to do this in Excel? Thanks and Have a great weekend, Pete -- peter_rivera ------------------------------------------------------------------------ peter_rivera's Profile: http://www.excelforum.com/member.php...o&userid=24495 View this thread: http://www.excelforum.com/showthread...hreadid=468343 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting problem | Excel Discussion (Misc queries) | |||
counting problem | Excel Worksheet Functions | |||
Problem with counting characters in a cell | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Counting problem again! | Excel Worksheet Functions |