getting the sum of variabel ranges

[Hein]

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

 

[Bob Phillips]

=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)

 

[Trevor Shuttleworth]

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]

Thank you Trevor for your reply

I actually tried this formula but must have done something wrong (dunno
what??)

I've tried it again and now I get the results I want!

Thanks again
Hein

 

[via135]

what results you got..GOK???!!!!

-via135

Thank you Trevor for your reply

I actually tried this formula but must have done something wrong (dunno
what??)

I've tried it again and now I get the results I want!

Thanks again
Hein