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!

	A	B	C	D
1	cash sales	$14000
2
3	expenditure distributions:	October	November	December
4	Price	152000	12000	13000
5	Tax	150	120	130
6	Fees	250	320	380
7	Marketing Expenditure

<tbody>
</tbody>

 

[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.