If multiple critera matches then return value

Hi,Hi,

This looks like a much simplified example and maybe doesn't represent the production data. We often find that when we give an answer to what is a trivial non representative example, when the solution is used with the real world data it doesn't work because of factors like different permutations, sorted/unsorted, string length and other stuff which is important but hasn't been mentioned.

We generally like to see the real workbook (or at least a cut down copy), and manually added results that you expect to see.

That said is there any reason to believe that the SUMIF won't return the same value for the same name? That would be the case if the data covered say different dates and you're looking for a total per day but your data doesn't suggest its anything other than a single day. In which case just wrap you formula in an =IF(COUNTIF()) formula

e.g.

Formula:

Please Login or Register  to view this content.

note the absolute and relative range references in the COUNTIF - this is important.