I am using the subtotal function to analyze data that I AutoFilter.
This works great for AVERAGE [ subtotal(1, A1:A500) ] or COUNT [ SUBTOTAL(2, A1:A500) ] but does not work for COUNTIF since is no function_num for COUNTIF, ie. SUBTOTAL (“x”, A1:A500), since COUNTIF needs a criteria…
Any easy solution to this?
This works great for AVERAGE [ subtotal(1, A1:A500) ] or COUNT [ SUBTOTAL(2, A1:A500) ] but does not work for COUNTIF since is no function_num for COUNTIF, ie. SUBTOTAL (“x”, A1:A500), since COUNTIF needs a criteria…
Any easy solution to this?