Using subtotals with a filter.

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Can you adjust the formula in the cell where the #N/A's are so that if the
result is going to be a #N/A that a "0" gets put there instead???

Put the below formula in all the cells where it may be possible for a #N/A
to show up in. Then your subtotal formula should work correctly.
=If(ISNA(yourformula),0,yourformula)

Hope that helps.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top