AVG row of data by Week ending
 

Column A Rows 4 -? = Date .......
Column Y = Seed Cost

I want to create a recap report that averages seed cost by Week ending Date?

Any help is greatly appreciated.

Carla

AVG row of data by Week ending
 

Need more detail.

Is the week ending on a Sunday? If so, does that mean you want the average
from Monday to Sunday?

Biff

"JmyCrikitt" wrote in message
...
Column A Rows 4 -? = Date .......
Column Y = Seed Cost

I want to create a recap report that averages seed cost by Week ending
Date?

Any help is greatly appreciated.

Carla

AVG row of data by Week ending
 

Thanks for your response.

Weekending is Sat. I want the average for sun through sat. Entries for
a week have multiple same date entries from 1-15 lines. I have 3 sheet
representing same infor 3 different entities all information sheets capture
the exact information and I want to recap by by entity. SHEETs 1-3
SOMETHING LIKE THIS:
Col A B ........ Q
Date ACRES $/AC
1/2/07 6 725
1/2/07 7 236
1/2/07 1.8 895
1/3/07 3 521
1/4/07 8 256
1/4/07 5 854
1/5/07 6 147
1/5/07 5 561
1/5/07 4.5 156
1/8/07 6 489 ETC...

RECAP SHEET4 - LIKE THIS:

A B C
WKEND $/AC $/AC
DATE sht 1 SHT 2
1/6/07 178 456
1/13/07 336 219
1/20/07 388 421

Hope this explains better what I am looking for. Appreciate your help.


"T. Val
ko" wrote:

Need more detail.

Is the week ending on a Sunday? If so, does that mean you want the average
from Monday to Sunday?

Biff

"JmyCrikitt" wrote in message
...
Column A Rows 4 -? = Date .......
Column Y = Seed Cost

I want to create a recap report that averages seed cost by Week ending
Date?

Any help is greatly appreciated.

Carla

AVG row of data by Week ending
 

If you have the week ending dates listed:

A B C
WKEND $/AC $/AC
DATE sht 1 SHT 2
1/6/07
1/13/07
1/20/07

Use a formula like this. This is an array formula. It must be entered using
the key combination of CTRL.SHIFT,ENTER (not just ENTER):

=AVERAGE(IF((Sheet1!A$2:A$11=A3-6)*(Sheet1!A$2:A$11<=A3),Sheet1!C$2:C$11))

Where E2 = weekend date 1/6/07

You'd have to add the appropriate sheet names where the raw data is located.

Once you have the first row of formulas in then copy down as needed.

Biff

"JmyCrikitt" wrote in message
...
Thanks for your response.

Weekending is Sat. I want the average for sun through sat. Entries
for
a week have multiple same date entries from 1-15 lines. I have 3 sheet
representing same infor 3 different entities all information sheets
capture
the exact information and I want to recap by by entity. SHEETs 1-3
SOMETHING LIKE THIS:
Col A B ........ Q
Date ACRES $/AC
1/2/07 6 725
1/2/07 7 236
1/2/07 1.8 895
1/3/07 3 521
1/4/07 8 256
1/4/07 5 854
1/5/07 6 147
1/5/07 5 561
1/5/07 4.5 156
1/8/07 6 489 ETC...

RECAP SHEET4 - LIKE THIS:

A B C
WKEND $/AC $/AC
DATE sht 1 SHT 2
1/6/07 178 456
1/13/07 336 219
1/20/07 388 421

Hope this explains better what I am looking for. Appreciate your help.


"T. Val
ko" wrote:

Need more detail.

Is the week ending on a Sunday? If so, does that mean you want the
average
from Monday to Sunday?

Biff

"JmyCrikitt" wrote in message
...
Column A Rows 4 -? = Date .......
Column Y = Seed Cost

I want to create a recap report that averages seed cost by Week ending
Date?

Any help is greatly appreciated.

Carla

AVG row of data by Week ending
 

Where E2 = weekend date 1/6/07

Ignore that sentence!

Biff

"T. Valko" wrote in message
...
If you have the week ending dates listed:

A B C
WKEND $/AC $/AC
DATE sht 1 SHT 2
1/6/07
1/13/07
1/20/07

Use a formula like this. This is an array formula. It must be entered
using the key combination of CTRL.SHIFT,ENTER (not just ENTER):

=AVERAGE(IF((Sheet1!A$2:A$11=A3-6)*(Sheet1!A$2:A$11<=A3),Sheet1!C$2:C$11))

Where E2 = weekend date 1/6/07

You'd have to add the appropriate sheet names where the raw data is
located.

Once you have the first row of formulas in then copy down as needed.

Biff

"JmyCrikitt" wrote in message
...
Thanks for your response.

Weekending is Sat. I want the average for sun through sat. Entries
for
a week have multiple same date entries from 1-15 lines. I have 3 sheet
representing same infor 3 different entities all information sheets
capture
the exact information and I want to recap by by entity. SHEETs 1-3
SOMETHING LIKE THIS:
Col A B ........ Q
Date ACRES $/AC
1/2/07 6 725
1/2/07 7 236
1/2/07 1.8 895
1/3/07 3 521
1/4/07 8 256
1/4/07 5 854
1/5/07 6 147
1/5/07 5 561
1/5/07 4.5 156
1/8/07 6 489 ETC...

RECAP SHEET4 - LIKE THIS:

A B C
WKEND $/AC $/AC
DATE sht 1 SHT 2
1/6/07 178 456
1/13/07 336 219
1/20/07 388 421

Hope this explains better what I am looking for. Appreciate your help.


"T. Val
ko" wrote:

Need more detail.

Is the week ending on a Sunday? If so, does that mean you want the
average
from Monday to Sunday?

Biff

"JmyCrikitt" wrote in message
...
Column A Rows 4 -? = Date .......
Column Y = Seed Cost

I want to create a recap report that averages seed cost by Week ending
Date?

Any help is greatly appreciated.

Carla