Got an answer by using SumProduct.

That said, is there not a function in Excel to directly read the SumIf
formula and Count the array items included?

EagleOne



On Jul 30, 9:34 am, EagleOne wrote:
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