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*2...
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))*$S2
SergeiBaklan , @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
