jasonjack
New Member
- Joined
- Apr 30, 2014
- Messages
- 26
- Office Version
- 365
- Platform
- MacOS
Hi,
Is it possible to have more than 2 criteria within the following formula?
CELL G7: =ArrayFormula(SUM(IF("APAC"=A2:A11, 1/COUNTIFS(A2:A11,"APAC",D2:D11,D2:D11,E2:E11,G6)),0))
The aim is to count the number of unique occurrences of APAC in weight 18.
CELL G8: =ArrayFormula(SUM(IF(FREQUENCY(IF(E2:E11=G6,IF(A2:A11=F7,MATCH(C2:C11,C2:C11,0))),ROW(C2:C11)-ROW(C2)+1),C2:C11)))
This then looks at the unique occurrences of APAC and sums the total minutes.
I would like to add Column D as another criteria within each calculation.
Many Thanks
Is it possible to have more than 2 criteria within the following formula?
CELL G7: =ArrayFormula(SUM(IF("APAC"=A2:A11, 1/COUNTIFS(A2:A11,"APAC",D2:D11,D2:D11,E2:E11,G6)),0))
The aim is to count the number of unique occurrences of APAC in weight 18.
CELL G8: =ArrayFormula(SUM(IF(FREQUENCY(IF(E2:E11=G6,IF(A2:A11=F7,MATCH(C2:C11,C2:C11,0))),ROW(C2:C11)-ROW(C2)+1),C2:C11)))
This then looks at the unique occurrences of APAC and sums the total minutes.
I would like to add Column D as another criteria within each calculation.
Many Thanks