HI

One way
=SUMPRODUCT((A1:A100="y")*B1:B100)*5%

--
Regards

Roger Govier


"Saintsman" wrote in message
...
Can anybody help with a formula please
Data is in columns & I need to apply an inflation % to a value IF
ColA=Yes &
add up the values of each
y/n bci end
n 701
n 727
y 766
y 801
y 931
inflate 5%
if(b2=y,c2*5%)+(if(b3=y,c3*5%).etc

So from above (766*5%)+(801*5%)+(931*5%) = 124.90
The column can grow & the 5% would need to be referenced

Thanks in advance for any help