COUNTIF Formula
Solved/Closed
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")
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")
Related:
- COUNTIF Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 20, 2009 at 09:13 PM
Aug 20, 2009 at 09:13 PM
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.
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.
Aug 21, 2009 at 11:43 AM
Thank you very mutch, The formula helped me lot, with this formula i am going to save 2 hours per day.