SUMPRODUCT and COUNTIFS formula that is returning #DIV/0!

Hello All,

I am trying to input a fomula to calculate the amount of unique values based on two criteria. Please see attached spreadsheet for reference.

If you look in cell D4 I have a formula that is calulating how many times cell C2 is showing on list M14 to M119. It is then looking for the amount of unique values from the destination column (G14 to G119) and returning that number to cell D4. Basically, it is calculating the amount of stops (unique destination location names) that are on a specific run.

My issue is that if I were to extend the range to row 200 (this would include blank cells), I am getting a return value of (#DIV/0!) because it is calculating the blank cells as zero value.

Please help!!!

Thank you in advance for your assistance!!!

Include iferror function

Please Login or Register  to view this content.

The second formula works perfectly!!! Thank you so much!!!