View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] steveqdr@yahoo.com is offline
external usenet poster
 
Posts: 2
Default How to indicate certain columns to be ignore in summation

Way cool. Thank you.

Steve

Dave O wrote:
Yes: use the SUBTOTAL(9,ref:ref) formula for all totals. Look up
SUBTOTAL in Help, and note the 9 is important (not a typo in this ng
post).

Cheers!
Dave O