The problem you have is that you are not clearly defining what you are trying to calculate.
Let $i \in \{1, 2, 3, 4, 5\}$ represent the week in which a game is played. We assume only one game is played per week. The score of the game in the $i^{\rm th}$ week is $X_i$ for you and $Y_i$ for your friend. Then we have $$X_i \sim \operatorname{Normal}(\mu_X = 175, \sigma_X = 30),$$ and $$Y_i \sim \operatorname{Normal}(\mu_Y = 150, \sigma_Y = 40).$$
Since we are asked to compare the total scores, over five weeks of play, it makes sense to define $$X = X_1 + X_2 + X_3 + X_4 + X_5, \\ Y = Y_1 + Y_2 + Y_3 + Y_4 + Y_5$$ as the sums of the scores for each respective player. Then the desired probability is $$\Pr[X < Y],$$ meaning your friend has a higher total score than you do.
Then, because the $X_i$ are independent and identically distributed normal random variables, $X$ is also a normal random variable whose mean equals $5\mu_X$, and whose standard deviation equals $\sqrt{5}\sigma_X$. And the corresponding situation is true for $Y$; i.e. $$Y \sim \operatorname{Normal}(5\mu_Y, \sqrt{5}\sigma_Y).$$ And since $X$ and $Y$ are independent, their difference is also normally distributed:
$$Y - X \sim \operatorname{Normal}\left(\mu = 5\mu_Y - 5\mu_X, \sigma = \sqrt{5\sigma_Y^2 + 5\sigma_X^2}\right).$$ Note carefully that although the mean is the difference of means, the standard deviation of the variance is not. This is because for independent random variables, $$\operatorname{Var}[Y - X] = \operatorname{Var}[Y] + \operatorname{Var}[X].$$
Now that we know how the difference in total scores is distributed, the desired probability $\Pr[X < Y] = \Pr[Y - X > 0]$ is expressible as a statement about a normal distribution with a known mean and known standard deviation. We can then standardize and compare this to a standard normal probability table; e.g., $$\Pr[Y - X > 0] = \Pr\left[\frac{Y - X - \mu}{\sigma} > \frac{0 + 125}{50\sqrt{5}}\right] = \Pr[Z > 1.11803].$$