A few words of thanks would be greatly appreciated.

Excel - Countif formula issue

Latest update on July 30, 2012 at 04:57 AM by aakai1056 .

Issue
Solution
Note that

Issue

In my Excel sheet, Column "B" has the "Pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3"

I want to count in the cells with the "Pending and Severity 2" status.
I am able to count below two formulas individually but I want to know how many Pending Severity 1 count.

=COUNTIF(B:B,"Pending")      
=COUNTIF(C:C,"Sevirity 1")

Solution

Suppose that your data is arranged like this:

A B C      
1 4      
2 5      
3 6      
4 7      
5 8      
pending severity 1      
7 1      
8 2      
pending severity 2      
9 4

In any empty cell use this formula, (modify it if needed):

=SUMPRODUCT((B1:B10="pending")*(C1:C10="severity 1"))

Note that

Thanks to venkat1926 for this tip on the forum.

This document, titled « Excel - Countif formula issue », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Apply an IF Function Using Dates and Text

Excel - Clear the contents of specific cells