G
Guest
Hello and thank you for responding.
I have a colum of data, that I am trying to sum. I am using the function
Subtotals to add the data displayed when I filter on another value of another
column. But since in some row there is a #N/A, it does not sum. What can I
do?
Function I use to sum is:
=SUBTOTAL(9,N9:N3000)
But it gives me and error if there is a value #N/A
Please advice.
Pester
I have a colum of data, that I am trying to sum. I am using the function
Subtotals to add the data displayed when I filter on another value of another
column. But since in some row there is a #N/A, it does not sum. What can I
do?
Function I use to sum is:
=SUBTOTAL(9,N9:N3000)
But it gives me and error if there is a value #N/A
Please advice.
Pester