Summing columns based on a date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am contructing a log that need to sum column based on the month. I need the formula to check that the row falls into a certain date range then sum the appropriate column if that argument is true
For the like of me I can't figure it out
Here is the function I am trying to use

=SUMIF(A31:A5000,Need the date criteria,E31:E5000
 
Hi,

Try,

=SUMIF(A31:A5000,">="&DATE(2004,2,1),E31:E5000)-SUMIF(A31:A5000,">"&DATE(
2004,2,28),E31:E5000)

or you may prefer,

=SUMPRODUCT(--(MONTH(A31:A5000)=2),--(YEAR(A31:A5000)=2004),E31:E5000)

Hope this helps!
 
Hi
try something like the following (for Jan 2004
=SUMPRODUCT(--(MONTH(A31:A5000)=1),--(YEAR(A31:A5000)=2004),E31:E5000)
 
Back
Top