Sum if Date is?

  • Thread starter Thread starter Jman
  • Start date Start date
J

Jman

Sum if Month is "01-01-08" , same with february and so on.

Column A1 to A365 i have dates for the whole year..The dates are not static
will automatically update at end of year.

These are the Table names for columns are (B:1 "60min), (D:1 "90min") , (F:1
"120min"), (H:1 "75min") , (J:1"15min") , (L:1 "30 min") , (N: "50min)". and
the table runs down to row 365 i have numbers that are automatically
transfered per correct Date in these columns "1" meaning one client "3"
meaning three clients.. in corseponding time columns.

I want a formula that will look at the date in and add the corresponging
total for each column "60 min" 90min" 120min, 75 min, 15min, 30min, 50min.
Per correct month. January totals thru December totals will be put in a
different table . In R:1 thru R12 i will have only names January -December.
In S1: S12 I need totals only for "60min" , In T1 to T12 for 90min, and so
on to X
 
Do you mean

=SUMPRODUCT(--(YEAR($A$1:$A$365)=2008),--(MONTH($A$1:$A$365)=1))

for January totals etc.

=SUMPRODUCT(--(YEAR($A$1:$A$365)=2008),--(MONTH($A$1:$A$365)=1),B$1:B$365)

for 60 min etc.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Yes,, Just what i wanted.
I have a question regarding. the "2008" in your formula.. Whe my dates
change to 2009. will your formula still read it? or. Do i need to do (Ctrl H)
and update the formula myself.
 
If you want that, try

=SUMPRODUCT(--(YEAR($A$1:$A$365)=YEAR(TODAY())),--(MONTH($A$1:$A$365)=1))


--
HTH

Bob

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

Bob Phillips said:
If you want that, try

=SUMPRODUCT(--(YEAR($A$1:$A$365)=YEAR(TODAY())),--(MONTH($A$1:$A$365)=1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top