SUMIFS where does not equal items from a range Hi, I have a sumifs with a few criteria, but want to add a criteria where column x does not equal one of certain names from sheet2 cells d2:d10, any ideas? Cheers View best response Labels: Formulas and Functions ...
Hi, I have a sumifs with a few criteria, but want to add a criteria where column x does not equal one of certain names from sheet2 cells d2:d10, any ideas? Cheers Formulas and Functions Reply OliverScheurich to JamesPhImpAug 03, 2023 JamesPhImp =SUMPRODUCT(($C$3:$C$14=$E...
Hi, I have a sumifs with a few criteria, but want to add a criteria where column x does not equal one of certain names from sheet2 cells d2:d10, any ideas? Cheers","kudosSumWeight":0,"repliesCount":3,"postTime":"2023-08-03T04:48:54.931-07:00","images":{"__typen...
Hi, I have a sumifs with a few criteria, but want to add a criteria where column x does not equal one of certain names from sheet2 cells d2:d10, any...