getting the sum of variabel ranges
 

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

getting the sum of variabel ranges
 

=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

getting the sum of variabel ranges
 

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

getting the sum of variabel ranges
 

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


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

getting the sum of variabel ranges
 

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

-via135




Hein Wrote:
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
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526339