Excel Question

[slickp]

I have a speadsheet with two columns in, and I would like to do a stats worksheet. Example of the two columns are as follows:

Operator Status
Donald Duck Quote
Donald Duck Bound
Mickey Mouse Quote
Donald Duck Quote

In the stats page I would like to show the number of Quotes quoted by Donald Duck, which in this case would be 2. Would it just be a case of a nested IFCOUNT formula? If so how would it look? Sorry never done an IFCOUNT before?

Cheers

 

[Fenrirshowl]

See Skipvought's SUMPRODUCT solution in the following thread

Excel Formula Count non-Adjacent cells
thread68-1274035

(Currently dated 8 Sept, roughly 25 threads down)

 

[bluedragon2]

see faq68-4725

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[arthurbr]

You might also use a pivot table for this purpose

 

[xlbo]

second that - pivot table would do the job well and very quickly

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[firefytr]

eh, I'll third that! This is classic Pivot Table data analysis!! They're different to get used to, but you'll love 'em in the end. ;-)

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci