The formula you have in the spreadsheet does not look like the formula you posted originally in this thread.
Here is what you have in the spreadsheet:
=SUMPRODUCT((terr=1),--(type="Regular Call Cycle"),--INT(date)>=startdate)--(INT(date)<=enddate)*(time)
You have missing --, you have missing commas, you have missing opening parentheses, etc....
The formula you posted originally, when pasted in your sheets results in 765
=SUMPRODUCT(--(Terr=1),--(Type="Regular Call Cycle"),--(INT(date)>=StartDate),--(INT(date)<=EndDate),Time)
Bookmarks