Google Sheets, CountIf, name matches and is within date range from another spreadsheet

Published: 14/11/2019
Google Sheets, CountIf, name matches and is within date range from another spreadsheet
Source: WEBAPPS.STACKEXCHANGE.COM

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 exampl

Read more
Related news
Comment
FACEBOOK