Forum Discussion
Pitso Mohlokwane
May 02, 2018Copper Contributor
Calculating monthly sales goals based on growth to target?
Hi guys I need help with a formula to dynamically re-calculate my target based on the actual input. On the screenshot from c4:n4 the user enters the percentage that must add up to 100%. H8 use...
Matt Mickle
May 02, 2018Bronze Contributor
Can you provide a non-sensitive sample file so that we can better understand your data representation, data structure and the existing formulas? It will make it easier for someone in the community to assist you with more detail.
Pitso Mohlokwane
May 02, 2018Copper Contributor
- Pitso MohlokwaneMay 02, 2018Copper ContributorSorry that is the picture on how the system looks
- Matt MickleMay 02, 2018Bronze Contributor
What about if O4 = SUM(C14:N14)-SUM(C13:N13)?
Maybe I'm missing something?