Is there a way when using the FILTER function that it will not add 0s if a cell is blank from where it is pulling data?

Question

I'm pulling the separate location lines from the master PO # tracker to their individual location sheets by using the FILTER function, but if a milestone is left blank on the PO # sheet, it pulls a 0 when I just want it be left blank. I'm struggling to find the right formula combination to do this and maybe it isn't possible. Can anyone help advise if what I'm trying to do is possible and if so how?

This is my current formula:
=FILTER('PO #'!A:H,('PO #'!B:B="NC")*('PO #'!H:H=""))

Answer 1

Hi Tiff Probst, 

Good day! Thank you for reaching out to the Microsoft Community. 

We appreciate your patience and effort in seeking a solution.  

I have researched and found the results as follows, it is displayed according to your needs: 

The Formula for NC is: 

=IF(ISBLANK(FILTER('PO #'!A:H,('PO #'!B:B="NC")*('PO #'!H:H=""))), "", FILTER('PO #'!A:H,('PO #'!B:B="NC")*('PO #'!H:H=""))) 

And for CA is: 

=IF(ISBLANK(FILTER('PO #'!A:H,('PO #'!B:B="CA")*('PO #'!H:H=""))), "", FILTER('PO #'!A:H,('PO #'!B:B="CA")*('PO #'!H:H=""))) 

Appreciate your patience with us.  
Looking forward to your response and have a great day ahead!!  
Best regards

Katherine V - MSFT | Microsoft Community Support Specialist

Answer 2

Hi Tiff Probst,

Is there any update on this thread? If the issue has been resolved, please mark the helpful replies as answers. This helps others in the community facing similar problems. Thanks for your understanding.

Appreciate your patience with us.

Looking forward to your response and have a great day ahead!!

Best regards

Katherine V - MSFT | Microsoft Community Support Specialist