Thread: How to Count the number of "rows" (or Array items) included in a Sumif formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EagleOne EagleOne is offline
external usenet poster
  
Posts: 68
Default How to Count the number of "rows" (or Array items) included in a Sumif formula?
2003/2007

Typical Sumif recap of a detail sheet. This is an XL question not
VBA.

The sum of the SumIf sub totals equals the grand total of the detail.

All is well in Heaven.

Now I want to know how many items are included in the Sumif SubTotals.

Is this possible? Do I need to use SumProduct?

TIA EagleOne

Reply With QuoteReply With Quote