AnsweredAssumed Answered

How to count if - (like conditional counting in Excel)?

Question asked by zvikaro on Apr 18, 2010
Latest reply on Apr 20, 2010 by mrvodka

Title

How to count if - (like conditional counting in Excel)?

Post

I have an list of cars, each listed with its manufacturers and model names. Since each manufacturer has few different model names, I want to have a report that will show the total number of models listed for each manufacturer's.

 

Sample data with 8 records:

---------------------------------------------------------

Audi A3

Audi Quatro

Audi Q7

Audi Q5

Fiat Brava

Fiat Punto

Fiat Uno

Skoda Fabia

---------------------------------------------------------

I need a report that will count the models for each manufacturer and list the following:

Audi - 4 records:      |  A3  |  Quatro  |  Q7  |  Q5  |

Fiat - 3 records:       |  Brava  |  Punto  |  Uno  |

Skoda - 1 records:   |  Fabia  |

-File Maker Pro 10 Advanced on Mac OS X 10.5.8

 

Urgent help appreciated.

Outcomes