Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]()
Assuming that your data contains text values and/or formula blanks,
try... =IF(COUNTIF(K4:Q4,"?*"),1,0) Hope this helps! In article , peter_rivera wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |