Hi all. I need some help with some functions to count text values. The situation is I need to look in column A for all of the cells that show "#N/A" (from a VLookup I did), and then look to column E and return a count for each of the text there (i.e. IN, OUT, LEAVE, etc...). My end goal is to create a table that is dynamic so that the counts for each text changes when I change the word in column E. I have attached the relevant columns in the spreadsheet.
Thanks!
take a look at using countif() or countifS(), i think they are what you need?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Use COUNTIFS
Hence,
=COUNTIFS(A:A,"#N/A",E:E,G2)
where G2 equals 'IN'
Adapt for the others
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks