ExcelBanter - =SUMVISIBLE(Q7..Q9)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =SUMVISIBLE(Q7..Q9) (https://www.excelbanter.com/excel-discussion-misc-queries/217134-%3Dsumvisible-q7-q9.html)

cruser

=SUMVISIBLE(Q7..Q9)

=sumvisible(q7..q9) just gives me #name?

Sheeloo[_3_]

=SUMVISIBLE(Q7..Q9)

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

"cruser" wrote:

=sumvisible(q7..q9) just gives me #name?

All times are GMT +1. The time now is 01:17 AM.