A Sum If one column is a specific description it changes the value.

[italianstallion]

formula1.jpg

Hi Again,

I am completely confused as to how to achieve what i am after, ill try explain i have added a screen shot.

if a single cell in column H = 'polish' then the value is taken from cell K and added to column 'I' to create a total amount.
if a single cell in column H = 'bevell' then the value is taken from cell N and added to column 'I' to create a total amount.
if a single cell in column H = 'clean cut' then the value is nothing or 0

Does this make sense?

Any help would be greatly appreciated.

Thanks.

[Ace_XL]

=IF(H2="clean cut",0,IF(H2="polish",K2,IF(H2="bevell",N2)+I2))

[italianstallion]

Thanks for the reply, with a few tweaks that worked, i will post soon.

The only extra is if the sum does not = any of these things how do i make it come up with error?

[Ace_XL]

This will give you a #VALUE error if none of the 3 are found

=IF(H2="clean cut",0,IF(H2="polish",K2,IF(H2="bevell",N2,"Error")+I2))