Thread: How to indicate certain columns to be ignore in summation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default How to indicate certain columns to be ignore in summation
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

Reply With QuoteReply With Quote