Integration (mathematical) problem

Does anyone know a quick way to integrate data in the mathematical sense (can't write the integration symbol on this keyboard!) For example, I want to perform the same very simple calculation 'n' times and sum the result E.g.

Sum((A1*A2)+(B1*B2)+(C1*C2) ... (DG1*DG2)+(DH1*DH2))

I don't have the luxury of an intermediate row to store the result of each multiplication which I can sum at the end and I really don't like the huge and repetitive formula (above) which I am using.

Surely there must be a function to do this but nothing jumps out at me and help wasn't... er... helpful!

Any suggestions appreciated!

Try the following...

=SUMPRODUCT(A1:DH1,A2:DH2)

Hope this helps!

Originally Posted by Jamie-nss

Does anyone know a quick way to integrate data in the mathematical sense (can't write the integration symbol on this keyboard!) For example, I want to perform the same very simple calculation 'n' times and sum the result E.g.

Sum((A1*A2)+(B1*B2)+(C1*C2) ... (DG1*DG2)+(DH1*DH2))

I don't have the luxury of an intermediate row to store the result of each multiplication which I can sum at the end and I really don't like the huge and repetitive formula (above) which I am using.

Surely there must be a function to do this but nothing jumps out at me and help wasn't... er... helpful!

Any suggestions appreciated!

Thanks Domenic,

That's got it! I had resorted to selecting ALL in "functions" and reading each one as I went down. Caffein levels must have been low when I passed over that one!

Thanks again,
Jamie