If OR and SUM formula

User251

Hi,

I created this formula but I'm not sure why I'm getting the error message "INVALID DATA TYPE"

=IF(OR(Name@row = "AB", "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))

Carson Penticuff

You are close, your syntax is just off by a bit.

=IF(OR(Name@row = "AB", Name@row = "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))

Carson Penticuff

You are close, your syntax is just off by a bit.

=IF(OR(Name@row = "AB", Name@row = "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))

User251

@Carson Penticuff It worked!! Thank you so much!! I truly appreciate your quick and very helpful response!