• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to do an allocation with formulas using criterias

becha69

New Member
hello, i am sorry if my english is not quite professional.
i dont know how to manage a set of formulas that can do apportionments of values based on fulfilling several conditions such as text string, value not equal zero, and sum of certain cells and values
can anyone please help?
i attaching a small example
i sincerely hope i have been more detailed in the explanation i edited in the sheet
thanks anyone for their time, expertise and lending a hand
 

Attachments

  • formulae for weight based allocation _criteria of text string and cells diff than zero and to...xlsx
    14.4 KB · Views: 5
Hi...
I did what I can..
hope this helps.
 

Attachments

  • formulae for weight based allocation _criteria of text string and cells diff than zero and to...xlsx
    15.9 KB · Views: 4
Here is a single formula option instead of Mayu's helper columns solution for your selection.

In K3, array (CSE) formula copied across and down :

=IFERROR(VLOOKUP(LEFT($F3,8),$F$25:$O$44,MATCH(K$2,$F$24:$O$24,0),0)*($J3/SUM((LEFT($F$3:$F$22,8)=LEFT($F3,8))*$J$3:$J$22)),0)

Array formula to be confirmed by pressing ("Ctrl"+"Shift"+"Enter") instead of just Enter.

78956
 
Last edited:
Back
Top