=sumif(2:2,9,3:3)

will check row 2 for a week number (such as 9), and sum the values in row 3

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"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