• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to ignore cells with "#N/A" using subtotal formula?

Hi all, I want to use the formula, e.g. subtotal (9, A1:A1000)...but there are #N/A in the column range. How to ignore cells with "#N/A" using subtotal formula? Thanks :)
 
Hi Rahul Shewale , thanks for the assistance. Greatly appreciated. I already have that formula but
Hi @delvillardennis ,

try this

=AGGREGATE(9,3,A1:A1000)

Thanks so much for the assistance. I already have the same formula but what I need is the function of the "subtotal" so that the sum of the data in the column range changes when filtering the spreadsheet. Sorry, my previous statement that I posted was not very clear. :)
 
As far as I can see that is exactly what the suggested formula does?? (AGGREGATE is a more elaborate version of SUBTOTAL)
 
Back
Top