sum formulas based on date

  • Thread starter Thread starter Jia
  • Start date Start date
You need to provide some details! Like:

Where is the data you want to sum?

What is its relationship to a particuler date(s)?

Where is the date(s)?
 
*smiles sheepishly*

2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value of
zero


1st worksheet: ITR SummaryA2 is actually =today()


I need to calculate the amount of hours worked per project, per day
--
Jia
Eclipser


T. Valko said:
You need to provide some details! Like:

Where is the data you want to sum?

What is its relationship to a particuler date(s)?

Where is the date(s)?
Click to expand...
 
Ok, we're making progress!
=SUMIF('ITR Summary'!A2,(C23:M23))
Click to expand...

I assume C23:M23 are the values you want to sum.

'ITR Summary'!A2 =TODAY()

Now, where are the dates that correspond to C23:M23?

I'll assume they're in C22:M22

=SUMIF(C22:M22,'ITR Summary'!A2,C23:M23)


--
Biff
Microsoft Excel MVP


Jia said:
*smiles sheepishly*

2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value
of
zero


1st worksheet: ITR SummaryA2 is actually =today()


I need to calculate the amount of hours worked per project, per day
Click to expand...
 
Oh dang, that's not how I set up the spreadsheet. *sighs*

Here's a quick overview...

Last Name Category1 Category2 Category3 Date Date Date

Any recommendations?
 
............A................B.................C.............D.......E.........F...
1...Category1...Category2...Category3...Date...Date...Date
2.........5.................7.................3..............x..................x..

x = today's date

=SUMIF(D2:F2,'ITR Summary'!A2,A2:C2)
 
=SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value

Does this make more sense now?

1st spreadsheet
a1: ITR Summary
a2: =today()

2nd spreadsheet
Last Name Category1 Category2 Category3 3/12/08 3/13/08
3/14/08
Jia 3 2 5
SUM SUM SUM
 
Does this make more sense now?

Well, not really. Maybe a fresh set of eyes will see what I'm not seeing.
 
Well, at this point there's not much more I can do unless you want to send
me a copy of the file or a sample file that shows me what you'e trying to
do. If you can/want to do that I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

If you do send me a file let me know in this thread. I don't always check
that mail account.
 
Back
Top