Problem calculating weekly costs
 

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 weekly
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 that
the same formula would search entire daily costs worksheet correctly?

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


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=506276

Problem calculating weekly costs
 

Use a pivot table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Student


"Handyy" wrote:


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 weekly
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 that
the same formula would search entire daily costs worksheet correctly?

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


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=506276

Problem calculating weekly costs
 

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

Problem calculating weekly costs
 

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

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


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=506276

Problem calculating weekly costs
 

Okay, thanks for getting back.

Pete