I'm trying to look on my Revenue Analysis tab for two criteria:
1. First criteria - does it find the value in $D$25 on the Revenue Analysis tab in the range $C2$1185. (It will find this multiple times.)
2. Second criteria, does it find the value in $N$1 on the revenue tab in the range $T$2:$T$1185. If/wherever it finds it, then SUM those values and divide by the value in $M$1
3. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$2 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$2
4. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$3 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$3
5. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$4 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$4
I've started here, but have become lost.
=SUMIFS('Revenue Analysis'!C3:C1185,$D$25,'Revenue Analysis'!T2:T1185,N1) "too many arguments"
Thanks in advance
1. First criteria - does it find the value in $D$25 on the Revenue Analysis tab in the range $C2$1185. (It will find this multiple times.)
2. Second criteria, does it find the value in $N$1 on the revenue tab in the range $T$2:$T$1185. If/wherever it finds it, then SUM those values and divide by the value in $M$1
3. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$2 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$2
4. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$3 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$3
5. Second Criteria continued - If instead of the value in $N$1 it finds the value in $N$4 in the range $T$2:$T$1185 SUM those values and divide by the value in $M$4
I've started here, but have become lost.
=SUMIFS('Revenue Analysis'!C3:C1185,$D$25,'Revenue Analysis'!T2:T1185,N1) "too many arguments"
Thanks in advance