Excel Counting Help Part II

Okay I had asked the following question and got a great answer

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

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

Two more minor follow ons...
1 how do you just get the total number of records in tab data?
2 how do you get record count for when data column P contains (not equal) but contains a certain value?
Matt PinkstonAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
To count the number of records you can use COUNTA like below...
=COUNTA(data!A:A)

Open in new window

And to count records in column P if it contains a part string/value like below...
=COUNTIF(data!P:P,"*<Value to search>*")

Open in new window

0
 
Matt PinkstonAuthor Commented:
GREAT!!!!!
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answer resolved the original question.
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.