Hello,
I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day.
Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets.
Question: Is there a formula I can use to do this?
This the one I tried but I keep getting a error, thoughts??
Wrong formula:
=COUNTIFS({Completed Calls - Dean MA Start Date}, >=DATE(2025, 12, 2), {Completed Calls - Dean MA End Date}, <=DATE(2025, 12, 2), {Completed Calls - Dean MA Outcomes}, "Mbr Reached" AND({Completed Calls - Medica MA Range 2}, >=DATE(2025,12,2), {Completed Calls - Medica MA Range 2}, <=DATE(2025, 12, 2), {Completed Calls - Medica MA Range 1}, "Mbr Reached")
