ryansapp
Board Regular
- Joined
- Apr 22, 2013
- Messages
- 54
A - Client numbers (duplicates when applicable along different lines of business)
K - fixed monthly number count per line of business
The CAPS sheet is our monthly recurring revenue.
I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having trouble and this is an easy one.
=IF(countif(A:A,A19)>1,K2/SUMIF(A:A,A19,K:K)*VLOOKUP(A19,CAPS!$B$1:$D$455,3))
K - fixed monthly number count per line of business
The CAPS sheet is our monthly recurring revenue.
I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having trouble and this is an easy one.
=IF(countif(A:A,A19)>1,K2/SUMIF(A:A,A19,K:K)*VLOOKUP(A19,CAPS!$B$1:$D$455,3))
