I’m struggling with formula, so I hope that you can help.
I have two table, Crew Schedule and Scorecard.
In the table Scorecard I would like to count how many time I enter different tags into the table Crew schedule and count them. Also I need to add a coefficient to certain tags.
For example, when the tag XXTRA is enter I would like to count it and multiplie it by 1.5.
So if the crew Tim Petit from Crew Schedule has 2 XXTRA tags, I would like to see the number 3 in my table scorecard (count 2 x 1.5 = 3)
Thanks for your help !