hidden rows

[richard oldcorn]

Is there any way to Sum (or COUNT,or whatever) a col of figures where some rows are hidden, so as just to add (or COUNT,or whatever) the visible rows?

Regards,


Richard Oldcorn
Sydney , Australia

 

[pgc01]

Hi Richard

You can use Subtotal(). Check the help for the syntax. It includes several options like Sum and Count.

 

[richard oldcorn]

Great, many thanks. Sumproduct(109,A1:A12) sums just as I want.

But not clear what you mean by "Always enclose code between the codetags

 and

"?

Regards,

Richard

 

[pgc01]

I'm glad it solves your problem.

But not clear what you mean by "Always enclose code between the codetags

That's for the case of vba code. You should always enclose vba code between the codetags or else you lose indentation and the code will be difficult to read.

ex.:

with codetags

With Worksheets("Sheet1")
    If Var1 = 3 Then
        For j = 3 To 10
            ' some code
        Next j
    End If
End With

without codetags:

With Worksheets("Sheet1")
If Var1 = 3 Then
For j = 3 To 10
' some code
Next j
End If
End With

 

[richard oldcorn]

Many thanks again-I'm still to learn VDA...


Regards,

Richard