Data Calulation Between Dates

  • Thread starter Thread starter Ghostrider123
  • Start date Start date
G

Ghostrider123

I'm trying to work with the formula:

=SUMIF(B3:B500,??????????????,G3:G500)

I want to be able to calculate data between two dates, let’s sa
between 1 July 2004 and 30 July 2004. I'm lost on how to figure tha
into the "criteria" section of this formula. Any help would b
appreciated. Thank
 
Hi Ghostrider123!

I have a schedule of dates in A1:A100
I have a schedule of amounts in B1:B100
I have an earliest date in C1
I have a latest date in D1

=SUMPRODUCT(--(A1:A100>=C1),--(A1:A100<=D1),B1:B100)

SUMPRODUCT approach uses SUMPRODUCT'S ability to handle multiple
conditions

Another:

=SUMIF(A1:A100,">="&C1,A1:A100)-SUMIF(A1:A100,">"&D1,A1:A100)

Double use of SUMIF says sum all above the earliest date and deduct
all above the latest date.

You'll need to decide what to do with your two boundaries.
 
Back
Top