Previous Topic Next Topic

COUNTIF Formula

[Solved/Closed]
Report
-
 Vijay -
Hello,

I have one excel file in that Colom "B" has the "pending or Closed" Status and Colom "C" has "Sevirity 1, Sevirity 2 and Sevirity 3"

I want to count in one cell with "Pending and Sevirity 2 tickets", please let me know which formual can help me.


I am able to count below two formulas indiveduvally, But i want to know how many Pending Sevirity 1 count.
=COUNTIF(B:B,"Pending")
=COUNTIF(C:C,"Sevirity 1")

1 reply

Answer 1 / 1
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
suppose your data is like this

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


in any empty cell use this formula

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

modify the formula to suiy you. the spellings must be exact. So copy paste.
Report

Hi Venkat,

Thank you very mutch, The formula helped me lot, with this formula i am going to save 2 hours per day.
Ask a question