COUNTIF Formula
Solved/Closed
Related:
- COUNTIF Formula
- Excel - Countif formula issue - How-To - Excel
- Countifs formula in excel with multiple sheets - Guide
- Countif formula in french - Guide
- How to count names in Excel: formula, using COUNTIF - Guide
- Spreadsheet formula - Articles
1 reply
venkat1926
Aug 20, 2009 at 09:13 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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.