getting the value of the cell that has a forumla and avoid circular warnings

I have a table that I had set up to figure out the amount that will cost for a certain user. The amount will change depending on the number of time this item is chosen (i.e. one item cost $60 and if 5 people chose this item, it will cost $12 per person because the cost is split between them). Then I want to have the sum of the amount added up.

Take a look here: http://prnt.sc/eo3tlb for what I have so far.

P5 and Q5 are the items A and B wants to order. The cost is split between them for a total of $30.50 per person. # of request will let me know simply how many people are requesting for this item.

What I want to do is instead of having the "x" in P5 and Q5, it turns into the cost of the item so I can do a sum (seen in P1 and Q1) of the total cost for all items for each person.

The only issue is each time i try different things, I either get an error or a circular warning. I get why I'm getting a circular warning but I don't know how to get around it.

For the # of request, I have this code: =COUNTA(C5:Q5) and for the Cost, I have =61/(COUNTA(C5:Q5). Any ideas on how I can get the value of the cost on the cell it's counting?

I've tried searching for a solution but nothing has worked so far.

Any help would be appreciated. Thanks!

You will be better off posting an example file for us/someone to use/work on.

Sorry! First time posting. Thanks for the instructions. I wasn't sure what to do next after uploading but here's the link I grabbed from the upload:

https://www.excelforum.com/attachmen...1&d=1490625505

Hope this works and thanks for your help!

I think I may be doing something wrong. I put it in the first column (in this case M) and changed the O to M and S to Q to match the two columns in question, but it's coming up as a value of "0".

Am I doing something wrong?

That was it! Thank you for explaining it. I apparently was having the case of the Monday and it didn't click. Thanks for all your help. This is exactly what I need.