This formula works: =SUMIFS(Numbers!F5:F8,Numbers!E5:E8,ReportCalculator!B20) I realize it only has one criteria to look at, but I'm taking this one step at a time.
What I need to add to this is for it to look in Numbers!F4:G4 and look for the value in ReportCalculator!$B$2
When I change this formula =SUMIFS(Numbers!F5:F8,Numbers!E5:E8,ReportCalculator!B20) to this: =SUMIFS(Numbers!F5:F8,Numbers!E5:E8,ReportCalculator!B20,Numbers!F4:G4,ReportCalculator!B2) I get a #VALUE! error.
The value in B2 is a fliter value I can select a date from that needs to change the data in the cell I'm looking at based on it's value.
Any ideas? thanks in advance
What I need to add to this is for it to look in Numbers!F4:G4 and look for the value in ReportCalculator!$B$2
When I change this formula =SUMIFS(Numbers!F5:F8,Numbers!E5:E8,ReportCalculator!B20) to this: =SUMIFS(Numbers!F5:F8,Numbers!E5:E8,ReportCalculator!B20,Numbers!F4:G4,ReportCalculator!B2) I get a #VALUE! error.
The value in B2 is a fliter value I can select a date from that needs to change the data in the cell I'm looking at based on it's value.
Any ideas? thanks in advance