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.

Excel - Countif formula issue
Excel @ in formula ✓ - Forum - Excel
How to copy data from one sheet to another in excel using formula - How-To - Excel
How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
Excel position formula ✓ - Forum - Office Software
Excel show formula bar - How-To - Excel

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

Issue

Solution

Note that

Subscribe To Our Newsletter!