I am trying to figure out how to add two cells on the same row if a cell to
the right is true.

I have a list of projects listed numerically by job number and the name of
the person assigned to that project in column "I". In columns "L" and "M" I
have a number associated with that project and would like to be able to add
this number on each row related to that person and return a total in one
cell. I have a table below these projects with each person listed in a
seperate row and the quantity of projects assigned to each person. right now
I am adding the cells manually to provide a total. sometimes there are 40 or
more cells to add.

any suggestions?