4 Replies Latest reply on Apr 20, 2010 8:47 AM by mrvodka

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

    zvikaro

      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.