............A................B.................C.. ...........D.......E.........F...
1...Category1...Category2...Category3...Date...Dat e...Date
2.........5.................7.................3... ...........x..................x..

x = today's date

=SUMIF(D2:F2,'ITR Summary'!A2,A2:C2)


--
Biff
Microsoft Excel MVP


"Jia" wrote in message
...
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?


--
Jia
Eclipser


"T. Valko" wrote:

Ok, we're making progress!

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

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" wrote in message
...
*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" wrote:

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)?


--
Biff
Microsoft Excel MVP


"Jia" wrote in message
...
How do I create a formula that will sum up a row based upon a
particular
date?
--
Jia
Eclipser