Return blanks instead of zeros if no data in column (MINIFS formula)

[lawi227]

I currently am using this formula:
=MINIFS(AH$71:AH$120,D$71:D$120,$D$4)

However, if there is no data in cells AH71:AH120, then it returns a zero. I want to formula to return blanks rather than a zero. How can I adjust my formula to do so?

Thanks in advance.

 

[lawi227]

UPDATE: I cleared the cells that were supposed to be empty and it removed the zeros. So when I pasted as values, something must have carried over. The formula works again. Thanks!

HI Steve the fish,

I started to populate my table with more data in cells 71:120, and all of the sudden there are 0.00 that started populating. Any way to troubleshoot? I searched the table to see if I accidentally copy and pasted 0.00 into the table but there are none. Any help would be much appreciated!

After doing some more troubleshooting, I realized that the formula may not have actually worked. It was only showing blanks for columns where there was no data. But lets say there is data in H71:H120 but it does not meat the first criteria (where $D$4 is equal to a cell in $D$71:D$120), then it returns 0.00.