Hein

=SUMIF(2:2,1,3:3) for week 1
=SUMIF(2:2,2,3:3) for week 2
=SUMIF(2:2,3,3:3) for week 3
=SUMIF(2:2,4,3:3) for week 4
=SUMIF(2:2,5,3:3) for week 5

Regards

Trevor


"Hein" wrote in message
...

Hi all


Who can help me with this:

I have to make a daily report in Excel.
My setup: in row 1 I have the date for each day in a particular month
Row 2: in the corresponding column I calculate the weeknumber
Row 3: in this row I fill in the sales.

So far so good.
What I would like to do: in another range I need to have the
_weektotals_

I have tried using a HLookup function using the idea :sum all sales
where weeknumber is (e.g.) 9.

I cannot use a "normal" reference as +d3+e3+f4 etc because the dates
are variabel.

Who knows what to do

Thanks in advance
Hein


--
Hein
------------------------------------------------------------------------
Hein's Profile:
http://www.excelforum.com/member.php...o&userid=24744
View this thread: http://www.excelforum.com/showthread...hreadid=526339