Hi,
I am trying to combine VLOOKUP and COUNTA and I am failing miserably. All of my data is in Sheet 1, totals are to be in Sheet 2.
I want to be able to look up a counsellors name (C1:C1000) and from that be able to count cells that have data in them in Q1:Q1000 (or column #15 in the range I am using... There are about 30 counsellors in this sheet, and the cells that I'm trying to count typically have dates in them.
Any help would be great! Thank you :)
Last edited by stephbrown; 03-27-2013 at 09:13 AM.
=COUNTIFS($C$1:$C$1000, A1, $Q$1:$Q$1000, "<>")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It didn't seem to... I get the #VALUE. This is what I end up putting in:
=COUNTIFS('Raw Data 2012-2013'!$C$4:$C$1000, I7, 'Raw Data 2012-2013'!$Q$1:$Q$1000, "<>")
Was A1 supposed to be the cell that I wanted to match?
Yes, so I assume I7 has the conciler's name in it.
=COUNTIFS('Raw Data 2012-2013'!$C$4:$C$1000, I7, 'Raw Data 2012-2013'!$Q$1:$Q$1000, "<>")
Those ranges must be the same C4:C1000 and Q4:Q1000
That seems to work better, but still brings up a value of 0 when it should be 10. Could it be something in the last section...
=COUNTIFS('Raw Data 2012-2013'!$C$4:$C$1000, I7, 'Raw Data 2012-2013'!$Q$4:$Q$1000, "<>")
See attachment. If you can upload an example spreadsheet (Go Advanced> Manage Attachments) maybe we can figure out what is wrong.
It works! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks