Hi - I am using the below formula to sum from a specific date range for specific locations, however, the formula is giving me a Value error. I would appreciate if someone help me with the formula.
SUMIFS('Consolidated Budget 2022'!$F$9:$NF$9, 'Consolidated Budget 2022'!$D$8:$D$134, 'Daily Sales'!AG29, 'Consolidated Budget 2022'!$F$5:$NF$5,">="&$BC$23,'Consolidated Budget 2022'!$F$5:$NF$5,"<="&(TODAY()-1))
Best regards
Khalid
Bookmarks