Forum Discussion
Assistant with adding up the number of Rows that meet multiple criteria
I would like to know the best way to add the number of rows that meet the numerous criteria on a different tab in the same workbook. For example. if 7 rows meet the same date, and an "x" marked in a ...
HansVogelaaryou are AMAZING! That makes perfect sense. When I use your template, I still get an error message. Below is what I have entered:
=COUNTIFS('Monthly Contacts'!$A$2:$A$300="2/7/21", 'Monthly Contacts'!$F$2:$F$300="x", 'Monthly Contacts'!$N$2:$N$300="Lionsgate - Heels - 113105", 'Monthly Contacts'!$P$2:$P$300="DSS")
I am clearly entering something wrong. Any thoughts?
The syntax of COUNTIFS is COUNTIFS(range1, condition1, range2, condition2, ...)
Change your formula to
=COUNTIFS('Monthly Contacts'!$A$2:$A$300, DATE(2021,2,7), 'Monthly Contacts'!$F$2:$F$300, "x", 'Monthly Contacts'!$N$2:$N$300, "Lionsgate - Heels - 113105", 'Monthly Contacts'!$P$2:$P$300, "DSS")
HansVogelaarYou are a lifesaver. THANK YOU! Works perfectly.