Hi,
I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.
I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)
Any Ideas ?
Cheers
Darren
I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.
I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)
Any Ideas ?
Cheers
Darren