View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel RS Nigel RS is offline
external usenet poster
 
Posts: 1
Default Conditional SumIf

Hi All
I have been successfully using sumif and countif to group summary results.
I also use subtotal to return sums and counts for autofiltered lists.

How do I combine autofiltered lists into my sumif and countif statements? I
could write the VBA code but would prefer a worksheet formula solution.
Thanks