Hope I can describe this accurately.....I'm trying to sum data on 2 criterias (Location Code, And Dates). I'm good with the location code because I have the range and I have the reference Location Code. I'm having an issue with the date's. Reason being that I have 2 ranges: I have the Raw data (contains all the data) and I have a list of dates that I want to sum from. On sumifs you have the Criteria Range and the Criteria, well I have the Criteria Range and the Criteria List. I thought that if I renamed the cells I would be able to sum the data that I needed, but I'm getting a 0.
Any ideas?
Heres the formula as a reference to what I'm doing....
=SUMIFS('Raw Data'!$G:$G,'Raw Data'!$A:$A,Sheet4!A24,'Raw Data'!$I:$I,NoSchool)
"NoSchool" Is the cell list of dates I renamed.
Appreciate any ideas on this.
Thanks,
Zeke
Any ideas?
Heres the formula as a reference to what I'm doing....
=SUMIFS('Raw Data'!$G:$G,'Raw Data'!$A:$A,Sheet4!A24,'Raw Data'!$I:$I,NoSchool)
"NoSchool" Is the cell list of dates I renamed.
Appreciate any ideas on this.
Thanks,
Zeke