0000000000
0000000000
Last edited by Dom.Knight; 05-12-2021 at 08:33 AM.
One way
=SUMIFS(Data!K:K,Data!P:P,A21,Data!E:E,B21,Data!F:F,C21)/SUMIFS(Data!L:L,Data!P:P,A21,Data!E:E,B21,Data!F:F,C21)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hello and thanks that does return the correct result. However if i drag up or down some of the other results it produces are not quite correct.
Example if i drag it up to H11 the result should be same as cell G11, F11 £2.22 But returns £8.89
Ah ok i see the error not sure how to correct it thoe. The price £100 is based on a full box for 45kilos (£2.22 Kilo) but in fact it was only a 1/4 box (11.25Kilos)
A start is for you to explain in english how you would treat it. Does it apply to any partial box?
In that case
=SUMIFS(Data!K:K,Data!P:P,A11,Data!E:E,B11,Data!F:F,C11)/SUMIFS(Data!L:L,Data!P:P,A11,Data!E:E,B11,Data!F:F,C11)*SUMIFS(Data!L:L,Data!P:P,A11,Data!E:E,B11,Data!F:F,C11)/SUMIFS(Data!G:G,Data!P:P,A11,Data!E:E,B11,Data!F:F,C11)
That works correctly.
And sheet "Data" is a helper sheet, Column K is the price per full box, when entered on sheet "Market" a box may not always be a full so inturn will be marked as 0.25/ 0.5 or 0.75. In retrospect i shoud install another helper column in "Data" to show that
Yes, I was going to mention that you use a helper column in the data to record the percentage of a full box weight and incorporate that column to cut down on the current formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks