OR in SUMIF function

Sharareh Zand

Hello,

I am trying to use OR in SUMIF function as below but get invalid operation error:

=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]84)

Sharareh Zand

Sorry, below if the formula I use:

=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, OR(({Confidence Level} = [Column11]84), ({Confidence Level} = [Column11]84)))

Paul Newcome

I am seeing a lot of different row numbers scattered throughout the formulas.

In your first formula you have

82

81

83

82

81

84

And in your second you have

82

84

81

Each across different columns. Can you verify that these formulas are referencing different rows?