create "IF" formula ?

B

Brent05Redfire

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?
 

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

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Is this possible?? 3
Counting same names in excel (Coulums) 1
Multiple Criteria Date Count formula 1
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Sum multiple cells if a column has a certain number in it 4
Count data in adjacent cell if criteria met 0
confused 1

Top