Sum a column based on a date

  • Thread starter Thread starter karstens
  • Start date Start date
K

karstens

I have invoice dates in Column A and their dollar amount in column F. I
would like to have another cell say January. And each invoice with a
date in January would be added there to make the Total for all invoices
in January. Is there a formula to do this?
 
=SUMPRODUCT(--(YEAR(A2:A200)=2005),--(MONTH(A2:A200)=1),F2:F200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

Date without true value 5
Need help creating a simple (?) SUM formula! 4
Year-to-date based on current month 2
sum column D based on column A 1
Sum multiple invoice number 6
I need help to make a not-so-easy AVERAGE formula! 4
Need help with SUMPRODUCT Formula 10
Calculating Monthly returns based on Dates 4

Back
Top