Related:

- Countif
- الدالة countif بالفرنسية - Guide
- 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?