How to Count the number of "rows" (or Array items) included in a Sumif formula?

EagleOne · Jul 30, 2007

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

EagleOne · Jul 30, 2007

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

Roger Govier · Jul 30, 2007

Hi

I don't think there is any way of doing that.
You could use COUNTIF with the same criteria as your SUMIF.

EagleOne · Jul 30, 2007

Hi

I don't think there is any way of doing that.
You could use COUNTIF with the same criteria as your SUMIF.

--
Regards
Roger Govier

- Show quoted text -

Thanks Roger.