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,
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
Try
=SUMPRODUCT(--('[Validation.xls]Sheet13'!H1:H3000=C3),
--('[Validation.xls]Sheet13'!K1:K3000>=TODAY()-7),
--('[Validation.xls]Sheet13'!K1:K3000<TODAY()))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
