Hello all,
I have a database that has named column ranges "terr, type, date, & time"
I want to sum all the values in the "time" range that match the terr#, Type, and between the two dates of Startdate and Enddate.
The formula below works but comes back with a very low amount so its either not summing the time and only counting instances or ????
I do not know. Help![]()
Thanks for any help you can give....
=SUMPRODUCT(--(Terr=1),--(Type="Regular Call Cycle"),--(INT(date)>=StartDate),--(INT(date)<=EndDate),Time)
Bookmarks