How to use COUNTIFS with multiple criteria?

Ryan Holguin

Hello All,

What would a formula look like if I need to count the following from another sheet:

Data I am trying to capture: Number of Catalogs and Design Guides Completed in 2022

Columns I need to reference:

Project Type (column 1)

1. Catalog
2. Design Guide

Status (column 2)

1. Completed

End Date (column 3)

1. 2022

I hope this is clear, but feel free to ask for me clarity!

Thanks,

Ryan H

Paul Newcome

You would have something like this:

=COUNTIFS({Project Type Column}, OR(@cell = "Catalog", @cell = "Design Guide"), {Status Column}, @cell = "Completed", {End Date Column}, IFERROR(YEAR(@cell), 0) = 2022)

Paul Newcome

You would have something like this:

=COUNTIFS({Project Type Column}, OR(@cell = "Catalog", @cell = "Design Guide"), {Status Column}, @cell = "Completed", {End Date Column}, IFERROR(YEAR(@cell), 0) = 2022)

Ryan Holguin

@Paul Newcome,

That worked! How much do I owe you????

Thanks,

Ryan H

Paul Newcome

@Ryan Holguin How about $100,000,000,000.00? 🤣