is this achievable

[swaink]

Hi All

This one sounded quite easy until I tried to explain what I was looking to achieve.

I have range in column B which contains numeric values an examle below

in coloumn C I have numeric values again, which represent a percentage i.e. 33 would be 33%

I want to take each row and calculate what the numeric value is if I divide col B by 100 then multiple by the value in col C, for example 100 in col B and 33 in Col C this would calulate a numeric value of 33

However I want to try and do all of the rows in one formula if this is possible.

Again an example would be as below the total result under Col C would be 1071

Col B Col C
100 33
100 33
1000 25
1000 28
1000 25
500 25
400 25

Does anyone know if I am barking mad or is it achieveable

All the best

Kevin

 

[VoG]

Try

=SUMPRODUCT(B1:B7/100,C1:C7)

 

[Ron Coderre]

With your posted data in B2:C8
this regular fomrula multiplies the Col_B value by the Col_C value divided by 100 and sums the products

=SUMPRODUCT(B2:B8,C2:C8/100)

Using your sample data, the formula returns: 1071

Is that something you can work with?

 

[swaink]

Hi Peter / Ron

This is excelent and so clean

I really appreciate your time

Thank you both this suits what I need very well

Best regards

Kevin