Thread: Sum If Visible
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lightbulb lightbulb is offline
external usenet poster
 
Posts: 61
Default Sum If Visible

I have a formula in a cell to sum based on different critieria....
=SUMPRODUCT(--($B$7:$B$399="F"),--(AD7:AD399<200),AD7:AD399) now I've added
a filter and only want it to sum the cells that are visible (b/c the filter
only makes visible the certain cells)...is there a way to do this?

Thanks!