Hi,
I would like to sum the values in column E based on the following criteria:
1. Values in column C >25
2. Values in column C <=50
3. Names in column F are "Apple"
4. Names in column G are "France"
All of these 4 conditions need to be satisfied for the values in column E to be added.
I tried SUMIFS but this doesn't return the answer I expected; I think that having two conditions applied to a single column (C) is causing the problem.
Can someone please suggest a solution.
Thanks!
I would like to sum the values in column E based on the following criteria:
1. Values in column C >25
2. Values in column C <=50
3. Names in column F are "Apple"
4. Names in column G are "France"
All of these 4 conditions need to be satisfied for the values in column E to be added.
I tried SUMIFS but this doesn't return the answer I expected; I think that having two conditions applied to a single column (C) is causing the problem.
Can someone please suggest a solution.
Thanks!