Hi,
I have data in cell A1:A100 and B1:100 now I have to multiply A1 with B1 and A2 with B2 ... A100 with B100 and sum everything. I want result in one cell.
Can I do this painless without doing A1*B1 in cell C1 and drag down? Can I do this in a one-liner?
I have data in cell A1:A100 and B1:100 now I have to multiply A1 with B1 and A2 with B2 ... A100 with B100 and sum everything. I want result in one cell.
Can I do this painless without doing A1*B1 in cell C1 and drag down? Can I do this in a one-liner?