Formula in table (A2:D2)*(M2:P2)/Z2

[drom]

Ho and Thanks in advance

I have a huge table (many rows, and columns)

In one of the columns I am at present using this formula:

• =((AL13*BD13+AM13*BE13+AN13*BF13+AO13*BG13+AP13*BH13)/AQ13)
• Works OK

I would like to use something easyer to check, Kind of:

• (BD13:BH13)*(AL13:AP13)/AQ13

 

[drom]

(SUMPRODUCT(BD13:BH13;AL13:AP13))/AQ13
Looks like this formula Works
Is it a good idea to use SUMPRODUCT inside a table ??

 

[Fluff]

How about

=sumproduct(BD13:BH13,AL13:AP13)/AQ13