SUMMATION on excel

[Rosiel]

I have a formula that calculates a price from values which is taken from an outside source (an SQL database). This is my formula so far, but it is very crude and limited.

=((SUM((B10/100*H10),(B11/100*H11),(B12/100*H12),(B13/100*H13),(B14/100*H14),(B15/100*H15),(B16/100*H16),(B17/100*H17),(B18/18*H18),(B19/100*H19))+B5)/B4)

Part of the formula is basically

= summation of ((B$10/100)*H$10), ((B$11/100)*H$11)... and so on. I'd like to know how I can write it so that it takes values from B10 to Bwherever/100 times H10 to Hwherever and then sums them up. The column itself has VARIABLE length, so ideally I'd like to know how set it so that it automatically detects the cells it has to put into the summation formula.

[ConneXionLost]

Hi Rosiel,

Here's a shorter way to write the basic formula:

Please Login or Register  to view this content.

While it doesn't deal with the "automatic detection", it would be easier to modify.

Cheers,

[Rosiel]

Many many thanks ConneXionLost for the quick response. I shall try this now!