Saturday, August 18, 2012

How to count how many times a name appears on one sheet

If you are wondering how to count a specific value (may be a number or a name or a date or any content of a cell) from a specific range of one sheet to another sheet of a spreadsheet then here is the formula.

Suppose you have a Sheet named "Summary" and you want to count how many times "John" appears in a range A4:S34 in the Sheet named "SignIn" (which is in the same spreasheet), then you can count it with the help of function "COUNTIF". Here is the formula:


Here, the above formula will return the number of times "John" appearing in Sheet named "SignIn".

No comments:

Post a Comment