Hi All,
I'm right on the edge of solving this but cannot understand why one aspect of my sumproduct is being ignored. 

=SUMPRODUCT(MAX(--(Company=$A6),--(Status=$D$4),--(Days Pending<>""),Days Pending))
What I want to do is show the maximum Days Pending per company in a list. The column that shows days pending already has a function in it - giving either a number value or ="".

I've been able to get the function to ignore the blanks in the list, but I'm getting the same value for all 3 Company results. i.e they should be different.
What have I done wrong?