phendrena
12-18-2008, 06:01 AM
Hi there,
I currently have the following formula :
=SUMPRODUCT(--('[Validation.xls]Sheet13'!H1:H3000=C3),--('[Validation.xls]Sheet13'!K1:K3000=H2))
I need to add into the above, a formula that will only display results in the last 7 days, the date range is in column 'K'. I have searched the forum as i know i've seen something before but wasn't able to find anything.
Please help.
Thanks,
I currently have the following formula :
=SUMPRODUCT(--('[Validation.xls]Sheet13'!H1:H3000=C3),--('[Validation.xls]Sheet13'!K1:K3000=H2))
I need to add into the above, a formula that will only display results in the last 7 days, the date range is in column 'K'. I have searched the forum as i know i've seen something before but wasn't able to find anything.
Please help.
Thanks,