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:
=COUNTIF(SignIn!A4:S34,"John")
Here, the above formula will return the number of times "John" appearing in Sheet named "SignIn".
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:
=COUNTIF(SignIn!A4:S34,"John")
Here, the above formula will return the number of times "John" appearing in Sheet named "SignIn".
No comments:
Post a Comment