Problem calculating weekly costs

[Handyy]

Hi,

This may seem a stupid question, but I just can't figure it out.

I have to worksheets, one for daily costs and second one for weekl
summary of costs.

Code
-------------------

DAILY COSTS
Week Weekday Costs
1 Mon 10€
1 Tue 8€
1 Wed 0€
1 Thu 3€
1 Fri 0€
1 Sat 0€
1 Sun 0€
2 Mon 16€
2 Tue 10€
2 Wed 2€
ect...

-------------------


Code
-------------------

WEEKLY COSTS
Week Costs
1 21€
2 28€
3 0€
4 0€
ect...

-------------------

How could I get data to each week with some kind of a search function
Like this: If A is 1, then add C to weekly costs, otherwise 0. So tha
the same formula would search entire daily costs worksheet correctly?

Hopefully I managed to make this explanation clear. Any advises ar
appreciated :

 

[Guest]

Use a pivot table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Pete]

Assume Week is in column A of both sheets, and Costs is in column C of
Sheet1. Enter the following formula in B2 of Sheet2 and copy down:

=SUMIF(Sheet1!A2:A100,A2,Sheet1!C2:C100)

Assumes data in Sheet1 extends to row 100 - adjust as necessary.

Hope this helps.

Pete

 

[Handyy]

Thanks a million, both replies are extremely helpful for me!

I'll use SUMIF for my current project but those Pivot Tables will com
in handy later on

 

[Pete]

Okay, thanks for getting back.

Pete