Forum Discussion
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/2022 to 31/07/2022? 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")
2 Replies
Does this work? I used the year 2022 as in your formula. If it should be 2020 as in your description, change both occurrences of 2022 to 2020.
=SUMIFS(AA2:AA100, I2:I100, "ROBOT", AD2:AD100, ">="&DATE(2022, 7, 1), AD2:AD100, "<="&DATE(2022, 7, 31))
- Sorry I put it 2020 which will be 2022 in stead. Thank you for pointing me the same.
