If statement adding values

[jbakerstull]

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

[sunny_talwar]

You sure can...

[rangam_s]

Thanks, the sum is showing as 23,585, may due to multiple records you had with same name.

Might be that was the reason Avg function worked for you

[jbakerstull · Accepted solution]

I just released that the formula is ignoring the programs that are selected in the  [Entry Exit Provider Name]  object.

What the formula is doing is adding all program values together. I just realized this after adding 72 additional programs to the formula.