I'm trying to make an IF statement that adds 1 for every set of cells that matches a certain criteria:
=SUM(IF(AND(Sheet1!A1=B2, Sheet1!C2=B3),1,0))
However, whenever I make a new sheet I want the B2 and B3 of that sheet to be included in the relationship. Is there a way to do this while also not including B2 or B3 in Sheet1?
Aucun commentaire:
Enregistrer un commentaire