Excel Countif Help

If I create a tab called totals and have a row labeled total active users how do I get the count of all records in tab data where column K=Active and column H=yes
Matt PinkstonAsked:
Who is Participating?
 
Bill PrewCommented:
Can you post a sample of the data?

Based on what you described, I think you want the COUNTIFS() function, something like this, but not sure I exactly understand your data layout:

=COUNTIFS(K:K,"=Active",H:H,"=Yes")

Open in new window


»bp
1
 
Matt PinkstonAuthor Commented:
worked great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.