I am trying to sum multiple cells if a number is in another cell. I have a
spreadsheet in which I have assigned numbers to each employees type of work
(ranging from 1 to 15) in column A and H. So if Column A has a 2, I need it
to take the value from that row in column F and add it to other number 2 job
duties. Trying to make an executive summary of the amount of time people work
on certain job functions/projects. I would also need it to add the same
number 2 job functions found in Column H taking the number of hours in the
row in column M. Hope that makes sense.