what I want to perform is: if "SUMIF('NJ'!A:A,C3,'NJ'!I:I)≠0", return the value of the "SUMIF('NJ'!A:A,C3,'NJ'!I:I)" if "SUMIF('NJ'!A:A,C3,'NJ'!I:I)=0", I want to use this formula "SUMIF('QJ'!A:A,C5,'QJ'!AC:AC)" to return the value. How do I put all this formula in one single cell? I just can't find the right answer on google, please help me ㅠ
Aucun commentaire:
Enregistrer un commentaire