Feb 07 2021 02:03 PM
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 different cell, and a specific text entered in another cell, and a specific text entered in another cell, then the value will show "7". Thanks so much for your help
Feb 07 2021 02:17 PM
You can use the COUNTIFS function. For example:
=COUNTIFS('Other Sheet'!$A$2:$A$100=D1, 'Other Sheet'!$C$2:$C$100="x", 'Other Sheet'!$E$2:$E$100="some text", 'Other Sheet'!$F$2:$F$100="other text")
Feb 07 2021 02:35 PM
@Hans Vogelaaryou 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?
Feb 07 2021 02:43 PM
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")
Feb 07 2021 02:48 PM
@Hans VogelaarYou are a lifesaver. THANK YOU! Works perfectly.