Excel 2016: Sumifs Conditions


How to add a date match as an AND condition to sum, when the values are horizontal/rows and are not equal. They do not match in size criteria; which is required for the sumifs function.

The date Mon 07/18/2018 (H23), needs to be a meet on the Original data tab, located G1:XFD1


=SUM(SUMIFS(‘Orig. Data’!I:I,’Orig. Data’!E:E, E23,’Orig. Data’!F:F,{“*POSITIVE WORK*”}),ISNUMBER(MATCH(H23,’Orig. Data’!G1:XFD1)))

By: April

Leave a Reply

Your email address will not be published. Required fields are marked *