NicholasP
Active Member
- Joined
- Nov 18, 2006
- Messages
- 291
I have a formula where I'm trying to use multiple criteria in an "OR" manner
=SUM(SUMIFS('Sheet1'!$R:$R,'Sheet1'!$K:$K,"Govt",'Sheet1'!I:I,{"Apple","Orange"},'Sheet1'!$O:$O,{"ONE","TWO","THREE"}))
So the idea is to sum if:
column K = Govt
Column I = Apple or Orange
Column O = One or Two or Three
I feel like I'm close, but
=SUM(SUMIFS('Sheet1'!$R:$R,'Sheet1'!$K:$K,"Govt",'Sheet1'!I:I,{"Apple","Orange"},'Sheet1'!$O:$O,{"ONE","TWO","THREE"}))
So the idea is to sum if:
column K = Govt
Column I = Apple or Orange
Column O = One or Two or Three
I feel like I'm close, but