FG
💻 Software

Count number of rows with conditions met in two columns

Fresh7 days ago
Mar 15, 202628204 views
Confidence Score0%
0%

Problem

I have some Excel columns that look like this. How can I write an Excel formula for: count the number of rows with 'James' in column B, and 'Upheld' in column C? I know how to do each of these conditions individually (using COUNTIF), but I'm not sure of the best way to combine them. Thanks!

Error Output

1774    David                    Not Upheld
1770    James                    Upheld
1771    David                    Upheld
1772    Sam              …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Count number of rows with conditions met in two columns

Low Risk

Use instead. The COUNTIFS function, similar to COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criteria. The ranges must be of identical size, and the function only counts instances where the criter…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment