create "IF" formula ?
 

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?

create "IF" formula ?
 

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?

create "IF" formula ?
 

Thanks! that did the trick.

"T. Valko" wrote:

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?

create "IF" formula ?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Brent05Redfire" wrote in message
...

Thanks! that did the trick.

"T. Valko" wrote:

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?