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