View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wngzro07
 
Posts: n/a
Default How do I count just the subtotals in Excel?

Hi,
I've got a worksheet that summarizes customer, date, and contract number
(over 9000 rows). I can get subtotals by using the Subtotal function of
Excel. However, I also need to count how many (within the subtotals only) are
over, under, or equal to say $100. Have looked all over and can't seem to
find a formula that ONLY counts the subtotals. All formulas seem to count
within the 9000 rows. Please help!