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