IF OR Syntax

[ddub25]

=SUMIFS(Table5[Total],Table5[Typ.],"Bank",Table5[Column2],$M$1,Table5[Column3],"A")

In the last part of thsi formula I'd like to adapt it to ask IF Column3 NOT = "NO" instead of IF = "A".

Can anyone help. Thanks.

Dan

 

[Jonmo1]

Try

=SUMIFS(Table5[Total],Table5[Typ.],"Bank",Table5[Column2],$M$1,Table5[Column3],"<>NO")

 

[ddub25]

Thanks Jonmo1, just what I wanted.

Dan