Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!