You can use an UDF like:

Function SkipHidden(sRange As Range)
Application.Volatile
Dim result
For Each cell In sRange.Cells
If Not Rows(cell.Row).Hidden Then
result = result + cell.Value
End If
Next
SkipHidden = result
End Function

Hope this helps,
Miguel.

"CLPoulos" wrote:

Is there a easy way to sum a column of numbers in excel and ignore hidden rows?