View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EricBB EricBB is offline
external usenet poster
 
Posts: 50
Default summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL

how to sum only the visible cells using SUMIF or SUMPRODUCT not SUBTOTAL