IF functions and working inbetween work sheets for football free kicks

[molemeister]

hi im trying to sort out a few football free kicks which im analysing. i know i've put alot of questions on this post, but im really struggling


i have a few problems with if functions

1) i want to make a new column (F) which will show whether the team is home or away. at the moment column 'E' only shows the name of the team. i would like column f to show whether the team in column e is the home or away team

eg
Home Team Away Team FK TEAM (F) New column
ASTON VILLA CHELSEA CHELSEA AWAY
ASTON VILLA CHELSEA ASTON VILLA HOME

2) could you also tell me how to do a count of column F. eg how many free kicks are 'home' and how many are 'away'

3) i would then like to know how many free kicks are won by the home side when winning, drawing and losing. The same for the away side. I know this can be done using column F and the information in column G

4) Finally - i have the total number of minutes which teams are winning, drawing and losing. i would like to ling 'sheet 1' with sheet 2 to show the minutes/free kicks in each section

I will very much appreciate some help on this.



i hope this is clear enough

[6StringJazzer]

#1-3 are easy, I suggest you look up COUNTIF in the Help pages.

I had to add a new formula in column K to solve this (may be possible without it but more straightforward with).

I couldn't figure out what you meant in #4, sorry.