Hi
I have following logic but can't create a sumifs Formula.
I have made following formula but it is not working;![]()
D1 Logic=Sumifs(Sum ColumnS IF ( the value in cell A1 matches with value in columnN AND the value in columnM is "pleted " AND (the value in ColumnP is nothing OR "" OR less than or Equal to 200) AND the value in columnR is (LessThan or EqualTo 6 OR Greater than 8) )
Any clue?![]()
=SUMIFS(S:S,N:N,A1,M:M,"pleted ",P:P,"<="&200,R:R,OR("<="&6,">"&8))
Bookmarks