sumproduct for getting counts

[Dan]

I am using a sumproduct formula to select certain criteria
and than return the Gross $$ amounts based on the
criteria. I am wanting to get a count on the same
criteria so that I and establish Averages. Can this be
done with sumproduct or is there another function. Here is
one of my current formulas :
=SUMPRODUCT((Month_rng=SelectMonth)*(Adj_rng<>"A")*
(Model_rng="UsdHvyTrk"),Gross_rng)

Any suggestions???

Dan

 

[Norman Harker]

Hi Dan!

Try:

=SUMPRODUCT((Month_rng=SelectMonth)*(Adj_rng<>"A")*(Model_rng="UsdHvyTrk"),Gross_rng)/=SUMPRODUCT((Month_rng=SelectMonth)*(Adj_rng<>"A")*(Model_rng="UsdHvyTrk"))

By omitting the column that contains the amounts, you'll get the count
for the three criteria.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.