Vlookups when list includes multiples

[ashleighfranklin]

Hi there,

I was hoping someone could help me with this. I have tried researching but am not getting anywhere...

Currently I am trying to do a vlookup, to see if I have booked in people for too many hours for any particular day (they are allowed 6 per day but it is tricky because they can be working across several projects).

So it looks something like this:
Project------Name of person allocated-----Monday-----Tues------Wed
Project X---------Person A-----------------------4-------------3-----------4
Project Y----------Person B-----------------------3-------------4-----------3
Project X----------Person C-----------------------6-------------6-----------2
Project Y----------Person A-----------------------3-------------3-----------2
Project Z----------Person A-----------------------2-------------6-----------2
Project X----------Person C-----------------------4-----------2-------------4

The problem is that Vlookup only returns the first item's corresponding cell. Because I need to know if a person has been overbooked for any particular day, I think I need a vlookup that sums all answers together. (I can then do conditional formatting so that if it exceeds 6 then it will show as red/flagged as an issue.

Any help would be greatly appreciated!!

Thanks in advance

 

[ChrisOswald]

Take a look at the sumif function.

if, B holds the peoples names, and C is the column for hours on monday, then

=sumif(b$2:b$100,"Person Name A",c$2:c$100)

will give the sum of the items in C that have a value in B of "Person Name A"

"Person Name A" can, of course, be replaced by a cell reference.

 

[ashleighfranklin]

Hey- thanks so much! That did the trick!
And thanks for being so quick to respond