Sum if Date is?
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)
"Jman" wrote in message
...
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
|