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