In another sheet I want to count how many meetings were scheduled for a rep within a date range.
My 3 columns are the date, rep, and misc data
=countifs(
"https://docs.google.com/spreadsheets/d/1q87c_0rFdt8FcWtIzD0KVW3k1ZpuvhfeWb1281MEs”,
”DEMOS!A2:C1000",
B2:B="Rep1",
A:A,">=11/9/2019",
A:A,"<=11/15/2019")
I'm a bit off it seems and I keep going around in circles.
Here is an example. I only want to count if Dates are between 11/9 and 11/15 and if the Rep is Rep1
A |B
-------------------
Date | Rep
-------------------
11/8 | Rep1
11/9 | Rep2
11/14 | Rep2
11/15 | Rep1
=Importrange()
because you can't import data from another spreadsheet like this. You can also share some sample data. – pjmg Nov 13 at 16:59