Hi everyone,
I have a condition that I want to use sumifs with and funtion.
Ex: The dropdown list (A2) is A, sumifs criteria of "123" and "456"
I have tried separate the criteria to 2, "sumifs(X:X,A2,"123",A2,"456) but does not work. Please advised and I appreciate your help!
I have a condition that I want to use sumifs with and funtion.
Ex: The dropdown list (A2) is A, sumifs criteria of "123" and "456"
I have tried separate the criteria to 2, "sumifs(X:X,A2,"123",A2,"456) but does not work. Please advised and I appreciate your help!