Hi. I trying to count through SUMIFS values from different columns.
I would like to avoid such formulas like:
โ=SUMIFS(RECEPTY!F:F;RECEPTY!E:E;C6)+SUMIFS(RECEPTY!H:H;RECEPTY!G:G;C6)+SUMIFS(RECEPTY!J:J;RECEPTY!I:I;C6)+SUMIFS(RECEPTY!L:L;RECEPTY!K:K;C6)+SUMIFS(RECEPTY!N:N;RECEPTY!M:M;C6)+SUMIFS(RECEPTY!P:P;RECEPTY!O:O;C6)+SUMIFS(RECEPTY!R:R;RECEPTY!Q:Q;C6)+SUMIFS(RECEPTY!T:T;RECEPTY!S:S;C6)+SUMIFS(RECEPTY!U:U;RECEPTY!V:V;C6)+SUMIFS(RECEPTY!X:X;RECEPTY!W:W;C6)+SUMIF(โOrder Detailsโ!C:C;A6;โOrder Detailsโ!D:D)+SUMIF(RECEPTY!C:C;B6;RECEPTY!B:B)โ
is there any easier way to sum the different values?
it is about the production site. I want to decrease stock level regarding both โOrder detailsโ and โComponentsโ to produce the product from order details.
LinkedIn
Twitter
