Related:
- Countif
- How to count names in Excel: formula, using COUNTIF - Guide
2 responses
A simple countif statement might be as follows:
=COUNTIF(B1:B200,"=Done")
This is stating that if the cells with the range of Column B state "done" it should count.
Fore your circumstance you will want to utilize a SUMPRODUCT formual to count how many of "Ajay"'s are "Done" verse other student names (Rai, etc).
=SUMPRODUCT((A1:A200="Ajay")*(B1:B200="Done"))
=COUNTIF(B1:B200,"=Done")
This is stating that if the cells with the range of Column B state "done" it should count.
Fore your circumstance you will want to utilize a SUMPRODUCT formual to count how many of "Ajay"'s are "Done" verse other student names (Rai, etc).
=SUMPRODUCT((A1:A200="Ajay")*(B1:B200="Done"))
Hi,
Thanx for my last query.
Please give me another solution for the under query:
If I have 3 column and 5 row data and ist column is date wise and other four have the status date wise. so how we can sum the data date wise using WEEKDAY function:
Example:
A B C
20/07/09 21/07/209 22/07/09
5 5 7
3 5 4
6 6 1
4 7 8
We want to sum weekly status using WEEKDAY function?
Thanx for my last query.
Please give me another solution for the under query:
If I have 3 column and 5 row data and ist column is date wise and other four have the status date wise. so how we can sum the data date wise using WEEKDAY function:
Example:
A B C
20/07/09 21/07/209 22/07/09
5 5 7
3 5 4
6 6 1
4 7 8
We want to sum weekly status using WEEKDAY function?
