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

E

EagleOne

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
 
E

EagleOne

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
 
R

Roger Govier

Hi

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

EagleOne

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 -
Click to expand...

Thanks Roger.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif for a specific number of cells 2
SumIF function 2
Using SUM + INDEX in array formula 5
Application hang with array sum(sumif... formula 7
How can I get a subtotal to appear in a column within a spreadshee 5
SUMIF w/ changing column refernce ... use an array? 5
count how many different numbers in the column and return to the n 2
Count the number of items received in a certain month 1

Top