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
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.