Counting in sheet

[UD]

hi,
i hav a sheet, in which i hav table containing readings of meters. in the
table there several columns like wise serial no., Property ,type, ratings,
accuracy, config. and many more. in config there are two categories. in
rating there are 5-6 categories and in accuracy there are 5-6 categories.
my problem is that i have to find out that in config(any one category), at a
particular Rating (any one category) , in a particular accuracy (it's also
any one category) how many number of consumers.
eg: in a single phase , at a rating of 10-60A, there are how many consumers
having the accuracy between 0to 1%. in this way i have to find out the number
of consumers in every phase at every particular rating, in every particular
accuracy.
i hav tried it formulaes but couldn't make it.
Pls help.

 

[Roger Govier]

Hi

Try Data>Filter>Autofilter

Use the dropdowns on the relevant column headings to make your selections,
and you will have a filtered list of those that meet your criteria.
Use Custom for some of the dropdowns, for example rating and set it to
Greater than or equal to 1 AND Less than or equal to 60

To get your Count, insert a new row above your header row and in the cell
above the heading Property enter
=SUBTOTAL(3,C3:C10000)

this assumes your Property column is C. Amend to suit your actual column

For more help on Autofilter take a look at
http://www.contextures.com/xlautofilter01.html