Problem with SUBTOTAL function

[dontaylor]

Hello

Please see attached file for problem with subtotal function

Thanks in advance for your help.

[Richard Buttrey]

Hi,

Your column F formula are returning text not numbers, i.e. string literals like "1", "0"

Use instead

Please Login or Register  to view this content.

[ConneXionLost]

It doesn't work because your formulas in the range are forcing the values to be text by using quotes around the numerals. Try changing the formulas like this:

Please Login or Register  to view this content.

[dontaylor]

Thanks, the problem is solved.