I am not sure which formula to use

[curiousmonkey]

A question came up on excel 2013 test to do the total amount of expenditure distributions (for each month) equal to 10% of the total cash sales (B1). i can't remember all the details;amounts, etc.. but it looked something like this:

I am not sure which formula to use because I don't see how the total can equal 10%. Would a SUMIF formula work here? If so, how do I go about it without using shortcuts, please? Thank you in advance!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]cash sales[/TD]
[TD]$14000
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]expenditure distributions:
[/TD]
[TD]October
[/TD]
[TD]November
[/TD]
[TD]December
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Price
[/TD]
[TD]152000
[/TD]
[TD]12000
[/TD]
[TD]13000
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Tax
[/TD]
[TD]150
[/TD]
[TD]120
[/TD]
[TD]130
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Fees
[/TD]
[TD]250
[/TD]
[TD]320
[/TD]
[TD]380
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Marketing Expenditure
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[tmmellor1981]

If you cannot provide the right question not sure you will get an answer. Based on what you have asked 10% of cash sales for oct is no where near the expenditure distrbutions you have provided.