12 Replies Latest reply: Jun 21, 2018 9:44 AM by Jeremiah Bakerstull RSS

    If statement adding values

    Jeremiah Bakerstull

      I'm trying to add to values together based on selections made from [Entry Exit Provider Name].

      If I just select 'LSS - FM Faith on 6th' the value returns 89.

      If I select 'LSS - FM Faith on 6th'  and 'LSS - FM Nancy''s Place', the return value is 27K.

      I expected the value to be 128. Need some help.



      =Sum(If(Match([Entry Exit Provider Name],'LSS - FM Faith on 6th'),89,

      If(Match([Entry Exit Provider Name],'LSS - FM Nancy''s Place'),39,0)))