Function that allows to plot graphs without 0s or N/A showing

Hi,

I have two functionss:

[CODE]$AD$2:$AD$10000,MATCH($B6&"-"&F$4,'171004.xlsx]export'!$C$2:$C$10000&"-"&'171004.xlsx]export'!$AB$2:$AB$10000, 0)),NA())/CODE]

Using the NA() at the end allows me to plot the graph with the NA()'s showing up as 0s. However if I try and find out the Max, Min, Average etc. of the range it results in #N/A.

The second funtions:

[CODE][/$AD$2:$AD$10000,MATCH($B6&"-"&F$4,'171004.xlsx]export'!$C$2:$C$10000&"-"&'171004.xlsx]export'!$AB$2:$AB$10000, 0)), "")CODE]

Using the "" allows me to return a value for Max, Min, Average etc. but the issues is when plotting the graph, those blank values show up as 0.

What's the best function to use?