Forum Discussion
=sum formula with variable values
RazmigVarsam You didn't enter any formulas. Entered them for you. Is that what you want?
See attached.
Riny_van_Eekelen I tried using your formula on my sheet it didn't work. Here's what my template looks like. The first box was my vlookup pivot where I have a total of five products and the two different payout percentages noted by NB and R. The second grid below that is the payout sample numbers noted in the Amount column. What am I missing here?
| Product | NB | R | |
| A | 9.00% | 9.00% | |
| H | 14.00% | 10.00% | |
| S | 15.00% | 15.00% | |
| C | 12.50% | 12.50% | |
| L | 55.00% | 5.00% | |
| Product | Amount | NB | R |
| A | $ 1,000.00 | $ - | $- |
| H | $ 5,353.00 | $ - | $- |
| S | $ 2,562.00 | $ - | $- |
| C | $10,000.00 | $ - | $- |
| L | $ 1,000.00 | $ - | $- |
RazmigVarsam Can't tell what's wrong without the file and seeing the formula used. Sorry!
Riny_van_Eekelen I actually don't have a formula other than the two you suggested. I can't seem to get that formula you provided in the sample file to work for the data grid below.
Product NB R A 5.00% 10.00% H 9.00% 5.00% S 10.00% 7.00% C 6.00% 6.00% L 25.00% 5.00% NB R A $ 1,000.00 $ - $- H $ 5,353.00 $ - $- S $ 2,562.00 $ - $- C $10,000.00 $ - $- L $ 1,000.00 $ - $- RazmigVarsam Can you share your file?
- I don't have access to upload a file. Please try this link, https://1drv.ms/x/s!Ajg9jrbpQkHdgdcj5xtlsmvwRaJ16g?e=IYGtIl.