lundi 26 septembre 2016

IF Statement in Excel using multiple worksheets

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