Calculate amounts depending on working days

[andsalex]

Hi to all,

I have for example 10 people working in my company with different salaries, i need to calculate the total amount per day depending on the salaries of working staff (if 1 means he is working)
On the example cell C13 should be 49950 as everyone is working. On D13 36321 as some of my staff is missing that day.

[AliGW]

In C13 copied across:

=SUMPRODUCT((C3:C12=1)*$L$3:$L$12)

or just:

=SUMPRODUCT(C3:C12*$L$3:$L$12)

[etaf]

edit - answered as i was typing

will the table and names line up as shown
a simple
=SUMPRODUCT(($L$3:$L$12)*(C$3:C$12=1))
will work for that
simply adds up the row value if there is a 1 in the row
but if the names may be in any order and different then may need to rethink

otherwise how will the data change

[andsalex]

Thank you both for your answers, it is working as mentioned, my mistake i didnt mention that what etaf wrote.... They names are in different order.

[etaf]

try
=SUMPRODUCT(($L$3:$L$12)*(C$3:C$12=1)*($B$3:$B$12=$K$3:$K$12))

[AliGW]

Seen, but no response ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[andsalex]

Thank you very much, it is working perfectly

[etaf]

you are welcome