Selecting Multiple Results

J

JAD

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
 
D

davesexcel

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
 
T

Toppers

Adjust as required:

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

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top