Hi,
I have the following formula in cell IC5:
I want it to exclude the zeros in range B:B on the sheet called "PO Value Data". This is what I have so far.
I have the following formula in cell IC5:
Code:
=DAVERAGE('PO Value Data'!$A:$B,2,IC3:IC4)
I want it to exclude the zeros in range B:B on the sheet called "PO Value Data". This is what I have so far.