winstalla

asked on

# Excel count matching criteria in multiple columns

I have an Excel Spreadsheet where I want to do something that seems very simple, but which is causing me some confusion.

Basically, I want to count the number of cells in column A that contain a specific value (e.g. "3") WHERE Column B on the same row matches another specific value (e.g. "4").

Example:

Column A Column B

3 4

3 2

3 3

3 4

2 4

I want the answer to be 2 (since only 2 rows match the two required criteria!). But I can't figure out how to do it.

I've tried a COUNTIF function, even putting in an AND function, but I can't get it to work out the answer properly. I've had a brief look at SUMPRODUCT but I can't work it out. That's probably just me being a bit thick.

Any help, please!

Basically, I want to count the number of cells in column A that contain a specific value (e.g. "3") WHERE Column B on the same row matches another specific value (e.g. "4").

Example:

Column A Column B

3 4

3 2

3 3

3 4

2 4

I want the answer to be 2 (since only 2 rows match the two required criteria!). But I can't figure out how to do it.

I've tried a COUNTIF function, even putting in an AND function, but I can't get it to work out the answer properly. I've had a brief look at SUMPRODUCT but I can't work it out. That's probably just me being a bit thick.

Any help, please!

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER