Hi,
I'm trying to SUM cell J4 across a range of worksheets but only SUM if a static date, K4, on the worksheets are equals too or less than today's date. This is my current attempt at getting this formula to work;
=SUMPRODUCT(SUMIF(INDIRECT("'"&O7:O20&"'!K4"),"=<"&I3,INDIRECT("'"&O7:O20&"'!J4")))
I've listed my worksheet names in O7:O20 and I3 has "=TODAY()" in, on the same worksheet I'm trying to sum up these values. I should get a value of £1460.04 back from at least 1 of the cells if this formula was working correctly, but I'm getting a value of £0.00.
I'm currently using Window 7 and Office 2010.
I'm trying to SUM cell J4 across a range of worksheets but only SUM if a static date, K4, on the worksheets are equals too or less than today's date. This is my current attempt at getting this formula to work;
=SUMPRODUCT(SUMIF(INDIRECT("'"&O7:O20&"'!K4"),"=<"&I3,INDIRECT("'"&O7:O20&"'!J4")))
I've listed my worksheet names in O7:O20 and I3 has "=TODAY()" in, on the same worksheet I'm trying to sum up these values. I should get a value of £1460.04 back from at least 1 of the cells if this formula was working correctly, but I'm getting a value of £0.00.
I'm currently using Window 7 and Office 2010.