+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    sydney
    MS-Off Ver
    Excel 2003
    Posts
    4

    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. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    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))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    sydney
    MS-Off Ver
    Excel 2003
    Posts
    4

    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. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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