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

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

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.

2. ## Re: A Sum If one column is a specific description it changes the value.

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

3. ## Re: A Sum If one column is a specific description it changes the value.

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?

4. ## Re: A Sum If one column is a specific description it changes the value.

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))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1