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.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

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

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

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

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.

Okay, thanks for getting back.

Pete