=sumvisible(q7..q9) just gives me #name?
S Sheeloo Jan 20, 2009 #2 I don't think SUMVISIBLE is a formula in Excel. What are you trying to do? If you want the total for visible items, try SUBTOTAL(9,A1:A100) and then filter...
I don't think SUMVISIBLE is a formula in Excel. What are you trying to do? If you want the total for visible items, try SUBTOTAL(9,A1:A100) and then filter...
