sumproduct with multiple criteria issue

hi there

having some difficulty with sumproduct and multiple criterias.

I have my revenue in column T "summary" sheet. I have the branch name in column "D" on summary sheet.

In the "offer" sheet, i have the "offered" revenue range.

in cell Y11 on the summary sheet, i would like to show what category the revenue falls under (cell range D8:I8 in offer sheet).

basically, for example,
Miami revenue = $80
therefore, in offer sheet, $80 falls between $83-$75 (i.e. List1 and List2). however, it should read as <$80 & >= $75, thus it becomes list 2.

I have attached a sample, if someone can pls help...ive been struggling for the half a day on this...pls and thxs.

FYI: if the price is less than "list 5" which is the bare minimum, then put "Less than".