Hey guys,

This is for work and I need some help figuring this problem out.

I have two worksheets- 1 labeled tracking and another called summary.

Tracking sheet tracks people that are requesting feedback, who has received feedback, who hasn't received feedback , how many days late the PM is late by person, etc.

The summary sheet looks like this

PM Days Late # late % on time
A
B
C
D
E
F
G
H
I
J
K
L
M
N

I am trying to get the summary sheet to search the tracking sheet by Project Manager and sum the 11th column titled "days late."

This is what I have so far:


SUMIF(Dayslate,VLOOKUP('Summary Sheet'!C4,'Tracking Sheet'!$B$3:$L$65,11,TRUE))
This formula didn't work because it gives me the same result regardless of who the VLOOKUP is searching for (Project Manager A,B,C,etc).

Thanks a ton for all the help!

Dorian Grey