Maybe this...

A1 = some name

=SUMPRODUCT((I2:I15=A1)*L2:M15)

--
Biff
Microsoft Excel MVP


"Brent05Redfire" wrote in message
...
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?