Forum Discussion
Help with formula
Hi. I am pretty much an excel novice and am struggling to get it to do a calculation that I need. I need to do a sum of the value in B2 multiplied by B19, all the way along so that I have a total o...
See OliverScheurich's reply.
Ah, I had thought he had written the same but I see it is different now.
Thanks so much OliverScheurich, that has saved my a lot of hassle.
Can I ask one more thing please? I now need to multiply the total of that previous formula by 1.2. Is there a way to add that into the formula?
Thanks
Thanks so much OliverScheurich, that has saved my a lot of hassle.
Can I ask one more thing please? I now need to multiply the total of that previous formula by 1.2. Is there a way to add that into the formula?
Thanks
=1.2*SUMPRODUCT(B2:Y2,B9:Y19)