[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]
For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.
I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.
Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.