Hi
See the attached file.
My query is based on a range of data contained on a 'Yearly" sheet.
Using the Monthly sheet in row 12, and using the cell ranges already populated, I would like to add the data in the ranges based on up to and including the date specified in G11 on the monthly sheet.
Obviously as the date is changed, the totals will change.
I've tried this formula but get a #VALUE error.
Can anyone help please.![]()
=SUMPRODUCT(DATE(Yearly!$E:$E,"<=$G$11",Yearly!$F$3:$X$4927))
Bookmarks