Data Calulation Between Dates

[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

 

[Norman Harker]

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.