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.

       

      Formula

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

       

      Thanks