sumproduct for getting counts

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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.
 
Back
Top