SUMPRODUCT or some similiar function
 

Need help with the function SUMPRODUCT, or some similiar function.

I'm looking for something to help me with my overtime schema.
I have to set a preset value that is hidden(this represents the cost of one
hour overtime), and let the users enter an integer greater than 0(this
represents their worked hours) and sum it all up in one cell without having
to have a row or column with the spesific price entered("hidden value").
E.g. The range A1:A10 is where the user can add hours. A11 is the cell that
should sum up the price of entered value(integer 0) in A1:A10*the cost off
one hour overtime.
If A1 is set to 3, and A2 is set to 1 and the "hidden" price of overtime is
200, then A11 should be 800.(since A1 is 3= (3*200) 600 + A2 is 1= (1*200)
200, and 600+200 = 800.)


Thanks in advance,

Lars Erik

SUMPRODUCT or some similiar function
 

Hi Lars

Is it not simply
=SUM(A1:A10)*200

--
Regards

Roger Govier


"Lars Erik N." <Lars Erik wrote in message
...
Need help with the function SUMPRODUCT, or some similiar function.

I'm looking for something to help me with my overtime schema.
I have to set a preset value that is hidden(this represents the cost
of one
hour overtime), and let the users enter an integer greater than 0(this
represents their worked hours) and sum it all up in one cell without
having
to have a row or column with the spesific price entered("hidden
value").
E.g. The range A1:A10 is where the user can add hours. A11 is the cell
that
should sum up the price of entered value(integer 0) in A1:A10*the
cost off
one hour overtime.
If A1 is set to 3, and A2 is set to 1 and the "hidden" price of
overtime is
200, then A11 should be 800.(since A1 is 3= (3*200) 600 + A2 is 1=
(1*200)
200, and 600+200 = 800.)


Thanks in advance,

Lars Erik

SUMPRODUCT or some similiar function
 

Thanks:)

"Roger Govier" wrote:

Hi Lars

Is it not simply
=SUM(A1:A10)*200

--
Regards

Roger Govier


"Lars Erik N." <Lars Erik wrote in message
...
Need help with the function SUMPRODUCT, or some similiar function.

I'm looking for something to help me with my overtime schema.
I have to set a preset value that is hidden(this represents the cost
of one
hour overtime), and let the users enter an integer greater than 0(this
represents their worked hours) and sum it all up in one cell without
having
to have a row or column with the spesific price entered("hidden
value").
E.g. The range A1:A10 is where the user can add hours. A11 is the cell
that
should sum up the price of entered value(integer 0) in A1:A10*the
cost off
one hour overtime.
If A1 is set to 3, and A2 is set to 1 and the "hidden" price of
overtime is
200, then A11 should be 800.(since A1 is 3= (3*200) 600 + A2 is 1=
(1*200)
200, and 600+200 = 800.)


Thanks in advance,

Lars Erik