=SUMPRODUCT(--($A$2:$A$100="Customer
1"),--($B$2:$B$100TODAY()-14),--($B$2:$B$100<=TODAY()-7)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
Hi All,
I have data that is setup with Owners in Column A and Date Purchased in
Column B.
What formula would I use to calculate the number of items that were
purchased by Customer 1 between 1 and 2 weeks ago?
THanks
Andi
|