Thread: sum visible row only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Qaspec Qaspec is offline
external usenet poster
  
Posts: 96
Default sum visible row only
I got it

=SUBTOTAL(9,M3:M3650)

Im an idiot

"Qaspec" wrote:

how do i sum visible rows and avoid summing hidden ones in a range?
Reply With QuoteReply With Quote