Count # of records based on date ranges

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]...
 
P

Peo Sjoblom

=SUMPRODUCT(--(MONTH(A2:A7)=E1),--(MONTH(B2:B7)=E2),--(YEAR(A2:A7)=2003),--(
YEAR(B2:B7)=2003))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column to row draging 1
Retrieve data based on 3 criteria 3
Select a cell based on an other cell's value 4
Count # of records based on date ranges 5
Selecting a range of cells based on the date. 1
Count/Sum rows of a column depending on criteria from drop-down li 4
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
Date ranges 1

Top