total number from start date to end date
 

I want to calculate the total of column G from particular date
period.

Anyone has ideas?

total number from start date to end date
 

=SUMIF(A:A,""&date_cell,G:G)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
ups.com...
I want to calculate the total of column G from particular date
period.

Anyone has ideas?

total number from start date to end date
 

i'll try a bob phillips approach:<g

assuming running dates are in a1:a25, this would sum everything in g within the
date range of a6:a20

=SUMPRODUCT(--(G1:G22),--(A1:A22=A6),--(A1:A22<=A20))

--


Gary


wrote in message
ups.com...
I want to calculate the total of column G from particular date
period.

Anyone has ideas?

total number from start date to end date
 

Now you are not saying I am obsessed with SUMPRODUCT are you <bg

Bob


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'll try a bob phillips approach:<g

assuming running dates are in a1:a25, this would sum everything in g
within the date range of a6:a20

=SUMPRODUCT(--(G1:G22),--(A1:A22=A6),--(A1:A22<=A20))

--


Gary


wrote in message
ups.com...
I want to calculate the total of column G from particular date
period.

Anyone has ideas?

total number from start date to end date
 

no, i just know who to ask if i have problems.

--


Gary


"Bob Phillips" wrote in message
...
Now you are not saying I am obsessed with SUMPRODUCT are you <bg

Bob


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'll try a bob phillips approach:<g

assuming running dates are in a1:a25, this would sum everything in g within
the date range of a6:a20

=SUMPRODUCT(--(G1:G22),--(A1:A22=A6),--(A1:A22<=A20))

--


Gary


wrote in message
ups.com...
I want to calculate the total of column G from particular date
period.

Anyone has ideas?