A function for counting record

Hello Everybody

I've a filemaker database with a field surname,a field family ,a field
with seat at cinema and a field Floor
 example

 Surname       Family        Seat          Floor

  Red               Red            seat n.1        1
  Red - wife      Red            seat n.2        1
  Black             Black         seat n. 3        1
  Black -Son     Black         Seat n. 4       1
  Green            Green        seat n. 10      2
  White            White         Seat n.18      2
  White - Son    White        Seat n.19      3
  White - Wife   White        Seat n.20      3

I have another table with filed family and Floor fields indicating the
total booked seat for a family in a

floor

 Family          First_Floor    Second_Floor   Third_floor

 red               2
 black            2
 green                             1
 white                              1                            2


How can calculate automatically the second table with filemaker?

Does exist a funciton like Count IF?

Best regards