(In B6) =SUMIF(A1:A5,NOT( [cell row hidden] ),B1:B5)
Or will I need to write a function to do this?
TIA
Charlie
Example:
Col_A has Name
Col_B has Amount
A2: Name
A3: Bill
A4: Dave
etc
B2: 10
B3: 20
etc
B1: =SUBTOTAL(9,B2:B10)
intially returns 30.
(The 9 in the SUBTOTAL function tells Excel to ADD the amounts, other
options are AVERAGE, MIN, MAX...etc....check Excel Help)
If you autofilter to only show Bill, the formula wil return 10.
Does that help?
***********
Regards,
Ron
--
Regards,
Tom Ogilvy
"Ron Coderre" <ronSKIPTH...@bigfoot.com> wrote in message
news:95053B54-9F40-4219...@microsoft.com...
***********
Regards,
Ron
Function SumVisible(rng As Range)
Dim cell As Range
For Each cell In rng
If Not cell.EntireRow.Hidden Then
SumVisible = SumVisible + cell.Value
End If
Next cell
End Function
=SumVisible(A1:A10)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Charlie" <Cha...@discussions.microsoft.com> wrote in message
news:7860ED4E-52B5-4713...@microsoft.com...