Selecting Multiple Results
 

I have a worksheet in which the user enter's a lowercase "x" in the L column
if they wish to calculate the Labor cost and/or a lowercase "x" in the M
column if they wish to calculate the Material cost and/or a lowercase "x" in
the E column if they wish to calculate the Equipment cost and/or a lowercase
"x" in the O column if they wish to calculate the Other cost. In most cases,
the end user will be calculating costs for more than just Labor or Material.
In some cases, the end user will be calculating the cost of all four
classifications; Labor, Material, Equipment and Other. Once the lowercase "x"
is entered into the appropriate cell, Excel will make a calculation by
multiplying an inputted quantity x cost per quantity unit for materials and
equipment. If labor is to be calculated it would be Quantity x Labor Hours
per Quantity x Labor Rate in Dollars. If I cannot find a function or custom
function to perform this function, I have to added a sum column for each of
the four types of costs per task line item. With the lowercase "X" feature, I
only need one sum column. Any help would be appreciated. Thank You, JAD

Selecting Multiple Results
 

maybe you can adjust this example to your needs

=IF(L1="x",A1*B1)+IF(M1="x",A2*B2)+IF(N1="x",A3*B3 )+IF(O1="x",A4*B4)
you can also multiply the nested if's if you need to


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=562709

Selecting Multiple Results
 

Adjust as required:

=(L1="x")*A1*B1+(M1="x")*A2*B2+(N1="x")*A3*B3+(O1= "x")*A4*B4

HTH

"davesexcel" wrote:


maybe you can adjust this example to your needs

=IF(L1="x",A1*B1)+IF(M1="x",A2*B2)+IF(N1="x",A3*B3 )+IF(O1="x",A4*B4)
you can also multiply the nested if's if you need to


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=562709