Hello, I understand this is a basic question but I was wondering if there was a short way to multiply two numbers on the same row (e.g. A1 & B1) and repeat this for as many columns as there is data in them (it can vary so could be A6*B6 OR A3*B3).
So if there is data in a1 & b1 all the way down to a6 & b6 I want all the individual columns to multiply eachother and then possibly present the total value of each added together
Bookmarks