Formula for % of ingredients in a list?

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

i would use the triangler number
=COUNTIF(B4:B23,"*")*(COUNTIF(B4:B23,"*")+1)/2

SO instead of the factorial which would be 13x12x11... you use 13+12+11+10... etc

on your example we work out the count and then the triangler number
so 13
is 91
and uses the formula above

then we use that as the value to find the % of
13/91
12/91
11/91

etc
so each count goes down a factor

And to add that all into 1 formula
=IF(B4="",0,COUNTIF(B4:$B$23,"*")/(COUNTIF($B$4:$B$23,"*")*(COUNTIF($B$4:$B$23,"*")+1)/2))

we count B4 to $B$23 which is 13 and divide it by that triangle mumber 91
next we only want to count to 12 so by having B4:$B$23
when we copy down - it will be B5:$B$23
and so count 12
divided by 91
and so on

now you have your proportional % dropping down for each entry

excellent thanks for letting us know
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here