software

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: www.excelforum.com/member.php...oamp;userid=30958
View this thread: www.excelforum.com/showthread...hreadid=506276Use a pivot table:

peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Studentquot;Handyyquot; wrote:

gt;
gt; Hi,
gt;
gt; This may seem a stupid question, but I just can't figure it out.
gt;
gt; I have to worksheets, one for daily costs and second one for weekly
gt; summary of costs.
gt;
gt; Code:
gt; --------------------
gt;
gt; DAILY COSTS
gt; Week Weekday Costs
gt; 1 Mon 10€
gt; 1 Tue 8€
gt; 1 Wed 0€
gt; 1 Thu 3€
gt; 1 Fri 0€
gt; 1 Sat 0€
gt; 1 Sun 0€
gt; 2 Mon 16€
gt; 2 Tue 10€
gt; 2 Wed 2€
gt; ect...
gt;
gt; --------------------
gt;
gt;
gt; Code:
gt; --------------------
gt;
gt; WEEKLY COSTS
gt; Week Costs
gt; 1 21€
gt; 2 28€
gt; 3 0€
gt; 4 0€
gt; ect...
gt;
gt; --------------------
gt;
gt; How could I get data to each week with some kind of a search function?
gt; Like this: If A is 1, then add C to weekly costs, otherwise 0. So that
gt; the same formula would search entire daily costs worksheet correctly?
gt;
gt; Hopefully I managed to make this explanation clear. Any advises are
gt; appreciated
gt;
gt;
gt; --
gt; Handyy
gt; ------------------------------------------------------------------------
gt; Handyy's Profile: www.excelforum.com/member.php...oamp;userid=30958
gt; View this thread: www.excelforum.com/showthread...hreadid=506276
gt;
gt;

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
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: www.excelforum.com/member.php...oamp;userid=30958
View this thread: www.excelforum.com/showthread...hreadid=506276Okay, thanks for getting back.

Pete