sum formulas based on date
 

How do I create a formula that will sum up a row based upon a particular date?
--
Jia
Eclipser

sum formulas based on 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)?


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

sum formulas based on date
 

*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

sum formulas based on date
 

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

sum formulas based on date
 

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

sum formulas based on date
 

............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

sum formulas based on date
 

=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

--
Jia
Eclipser


"T. Valko" wrote:

............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

sum formulas based on date
 

Does this make more sense now?

Well, not really. Maybe a fresh set of eyes will see what I'm not seeing.


--
Biff
Microsoft Excel MVP


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

--
Jia
Eclipser


"T. Valko" wrote:

............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

sum formulas based on date
 

Maybe this is what you're trying to do:

http://img515.imageshack.us/img515/8348/sumva9.jpg


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Does this make more sense now?

Well, not really. Maybe a fresh set of eyes will see what I'm not seeing.


--
Biff
Microsoft Excel MVP


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

--
Jia
Eclipser


"T. Valko" wrote:

............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

sum formulas based on date
 

Nothing happens when I double click on the hyper link. *sighs*

Wannetta.Thomas @EclipseAviation
--
Jia
Eclipser


"T. Valko" wrote:

Maybe this is what you're trying to do:

http://img515.imageshack.us/img515/8348/sumva9.jpg


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Does this make more sense now?

Well, not really. Maybe a fresh set of eyes will see what I'm not seeing.


--
Biff
Microsoft Excel MVP


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

--
Jia
Eclipser


"T. Valko" wrote:

............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

sum formulas based on date
 

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.


--
Biff
Microsoft Excel MVP


"Jia" wrote in message
...
Nothing happens when I double click on the hyper link. *sighs*

Wannetta.Thomas @EclipseAviation
--
Jia
Eclipser


"T. Valko" wrote:

Maybe this is what you're trying to do:

http://img515.imageshack.us/img515/8348/sumva9.jpg


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Does this make more sense now?

Well, not really. Maybe a fresh set of eyes will see what I'm not
seeing.


--
Biff
Microsoft Excel MVP


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

--
Jia
Eclipser


"T. Valko" wrote:

............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