Hi,
I am trying to count the number of non-blank cells in column DF (of the Master worksheet) for values in column DA (of the Master worksheet) that match the criteria in cell B4 (of the 2013 List sizes worksheet). I have the formula as per below but its not giving me the correct result. Can someone point me in the right direction?
=COUNTA(IF(MASTER!DA:DA='2013 List sizes'!B7,MASTER!DF:DF))
The answer should be 4 but it returns 65536.
Any assistance would be appreciated!
Thanks.
Maybe?
=COUNTIF(MASTER!DA:DA,'2013 List sizes'!B7,MASTER!DF:DF))
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.
Hi, unfortunately that didnt work. The cells in MASTER!DF:DF are not equal to '2013 List sizes'!B7. I just want to see how many aren't blank. Thanks.
From your first post
From your last post.=COUNTA(IF(MASTER!DA:DA='2013 List sizes'!B7,MASTER!DF:DF))
..The cells in MASTER!DF:DF are not equal to '2013 List sizes'!B7.
So this make no sense for me. Sorry.
1) Your working in Excel 2003?
Please Login or Register to view this content.
And
2) MASTER!DA:DA='2013 List sizes'!B7 = empty
then you get the result 65536 (all cells in the column).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks