Excel: Sumif with filtered rows 1

[ebrooks54]

I'm looking for a way to create something that duplicates the way the sumif function works in Excel, except that it works the way the subtotal function works and ignores rows that are hidden because of an auto-filter.

Alternately, is there a function that indicates whether a row is hidden or not? Does anyone have the code for a user defined function that would indicate whether a row is hidden?

Thanks

 

[SkipVought]

Hi,

Function SumVisible(rng As Range)
    Dim r As Range
    Application.Volatile
    For Each r In rng
        If Not r.EntireRow.Hidden Then
            SumVisible = SumVisible + r.Value
        End If
    Next
End Function

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}