Advanced Filtering

Wendybird · May 8th, 2002, 11:14 AM

We have a database of sites numbered 1-800ish. Each site has an owner, a current distributor and a proposed distributor. What is the best way to summerize the number of sites (count) under the current distributor and also the proposed distributor for each owner? (in a report format). I have used an advanced filter to return unique values of owner name and current distributor/proposed distributor, but I can't figure out how to count each instance of the unique value. Do I use COUNTIF seperate from the advanced filter, or can I filter using a specific criteria.?? UUGGHH!

[ This Message was edited by: Wendybird on 2002-05-08 10:42 ]

Chris Davison · May 10th, 2002, 09:51 AM

Wendy,

COUNTIF only works for a single criterium, but you look like you need two criteria

have you thought about =SUMPRODUCT ?

or also, maybe a pivot table would also do the job ?

May 10th, 2002, 09:51 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Wendy, COUNTIF only works for a single criterium, but you look like you need two criteria have you thought about =SUMPRODUCT ? or also, maybe a pivot table would also do the job ? __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 11:14 AM	#1
Wendybird New Member Join Date: May 2002 Posts: 3	We have a database of sites numbered 1-800ish. Each site has an owner, a current distributor and a proposed distributor. What is the best way to summerize the number of sites (count) under the current distributor and also the proposed distributor for each owner? (in a report format). I have used an advanced filter to return unique values of owner name and current distributor/proposed distributor, but I can't figure out how to count each instance of the unique value. Do I use COUNTIF seperate from the advanced filter, or can I filter using a specific criteria.?? UUGGHH! [ This Message was edited by: Wendybird on 2002-05-08 10:42 ]