Formula to Count Criteria from Multiple Cells

Jackson Pavelka
Jackson Pavelka ✭✭✭
edited 12/11/20 in Formulas and Functions

Hi there,

I have a reference sheet from which I need to reference two full columns...

I need to write a formula to count the number of records where Column 1 equals A, and Column 2 equals B, C, or D. I have been working with =Countif and =Countifs but have been unable to find a suitable method of writing this formula. It is the need for an OR function that is throwing me off.

Anyone have ideas? Thanks in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!