Adding a range of cells based on a criteria and date range
Hi,
Can anyone please guide me adding cell range from AA2 to AA100 when cells I2 to I100 having value “ROBOT” and cell AD2 to AD100 contain date range from 01/07/2020 to 31/07/2020? The date format is DD/MM/YYYY.
I used the following formula but it is not working:
=SUMIFS(AA2:AA100, I2:I100, “ROBOT”, AD2:AD100, “>=01/07/2022”, AD2:AD100, “<=31/07/2022”)
Hi,Can anyone please guide me adding cell range from AA2 to AA100 when cells I2 to I100 having value “ROBOT” and cell AD2 to AD100 contain date range from 01/07/2020 to 31/07/2020? The date format is DD/MM/YYYY.I used the following formula but it is not working:=SUMIFS(AA2:AA100, I2:I100, “ROBOT”, AD2:AD100, “>=01/07/2022”, AD2:AD100, “<=31/07/2022”) Read More
