I have a situation where i would like a cell to be treated as blank so i can use the COUNTA function,
the formula I currently use sets the cells to empty
=IFERROR(IF(INDEX($A$1:$A$15,H2,)=0,"",INDEX($A$1:$A$15,H2,)),"")
don't need to worry about the workings behind it but essentially is there a way to get excel to read the "" as blank?
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
One way could be this.
=COUNTIF(B1:B10,"<>""")-COUNTIF(B1:B10,"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
yeah i thought about that one also. ill see if i can get it to work around.
if there are any other ideas im all ears
thanks though
Assuming the returned values are text (otherwise you would use the COUNT() function):
=COUNTIF(B1:B10,"?*")
both work lovly. thanks.
i really like that last one cutter
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks