Hi
I would suggest using SUMPRODUCT instead. e.g. if your dates are in
column A and you values in column B use
=SUMPRODUCT((A1:A100>=DATE(2004,1,1))*(A1:A100<DATE(2004,4,1)),B1:B100)
This way you don't have to create a separate criteria range
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.
