Forum Discussion
Complicated? Sum Question
Good Afternoon!
Currently trying to create a formula to calculate the value for Column "U".
I've completed Column "R" and it is calculated by the formula in the text input, using "=Sum(L2*26)+(M2*25)+(N2*19)+(O2*15)+(P2*8)". The number the columns are being multiplied by match the "bid items" from the Column "X".
My issue is that Column "U" will need to value check from "L,M,N,O,P" against "S" and use "S's" quantity in place of which ever column "L,M,N,O,P" has a value greater than Zero and needs to multiply by the correct "Bid Item" Rate.
I've checked different sites looking for guides but can't seem to figure it out. Any and all help is appreciated. Currently using Office 365 version of Excel and have attached a .PDF shot of the sheet I'm working on.
Thanks in advance,
B
3 Replies
In R2 it could be
=SUMPRODUCT($L2:$P2*TRANSPOSE($X$4:$X$8))and in U2
=SUMPRODUCT(($L2:$P2>0)*TRANSPOSE($X$4:$X$8))*$S2SergeiBaklan , @Subodh_Tiwari_sktneer
Thank you for your replies and apologies for the delay.
Attached is the sample piece I am using for this data as I still need a little help apparently. I am coming up with a "#value!" error on this spreadsheet when I use the formulas provided. Could you please point me in the right direction to what I am doing wrong?
Also, fairly new to posting, so should have attached the the excel in the original and not a .PDF. Wasn't thinking and caused you folks to input the data manually. Sorry about that.
Thanks in advance,
B
