Count # of records based on date ranges

  • Thread starter Thread starter Jennifer L.
  • Start date Start date
J

Jennifer L.

Thank you everyone for your help with this! I have got
this to work now, but I have realized that I have data in
my list from 2002.
Is there a way that I can retrieve only the results for
2003?

Thanks again - any help is appreciated!
Jennifer

-----Original Message-----
Jennifer,

Setup:
your data in A1:B7
In D1:E2
Returned in: 12
Purchased in: 10
In F1
=SUMPRODUCT((MONTH(A2:A7)=E1)*(MONTH(B2:B7)=E2))

Dan E

"Jennifer L" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
=SUMPRODUCT(--(MONTH(A2:A7)=E1),--(MONTH(B2:B7)=E2),--(YEAR(A2:A7)=2003),--(
YEAR(B2:B7)=2003))
 
Back
Top