SUBTOTAL function returning incorrect value

[jomurray]

Hello, I'm having some difficulty with the SUBTOTAL function. I'm looking to find the sum of a range within a filtered spreadsheet. I entered =SUBTOTAL(9,

#VALUE!

 

[FormR]

Hi, welcome to the forum! It looks like it might be the result of a floating point rounding error (google will reveal some good explanations) - you could try removing it with:

=ROUND(SUBTOTAL(9,

#VALUE!

 

[jomurray]

Worked like a charm! Many thanks