M
Mike
Can anybody help with the following,
I have table numbers (1 - 10) in Col A and a menu choice (Text) in Col
C. I need to calculate the total of the menu choice for each table. I
have used =COUNTIF(C5:C100,"Prawn Cocktail")which gives me a total for
all ten tables, but I needing to calculate a total for each table.
Thanks in anticipation.
Mike
I have table numbers (1 - 10) in Col A and a menu choice (Text) in Col
C. I need to calculate the total of the menu choice for each table. I
have used =COUNTIF(C5:C100,"Prawn Cocktail")which gives me a total for
all ten tables, but I needing to calculate a total for each table.
Thanks in anticipation.
Mike