# Countif

Closed
Raj - Jul 24, 2009 at 08:58 AM
Raj - Jul 25, 2009 at 02:44 AM
Hello,

I have 2 column in excel sheet. In 1st column i have student name and in another column i have the files status i.e. done or in process. so i want to count the done files of particular student.

Example:
Raj Done
Ajay Done
Raj In process
Ajay Done
Raj Done

So i want to count the done files of Raj.
Ans: 2

So how can we count.

Regards,
Raj

## 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"))
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?