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

Start/finish but work is only a couple hours 1
Multiple animations 0
Tracking Resources as Trade Types - Rather than Individuals 1
How to implement two shifts per day with multiple teams 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Slideshow with black border around it 0
Cumulative formula for word table 0
Centered text that does not stay centered 0

Top