I have this formula that sums a column if it matches “dog” on column A on a sheet named “1.”
=SUMIF('1'!$a:$a,”dog”,'1'!$b:$b)
Is there a way to automate changing that sheet to “2,” then "3," ... for the next cells?
i.e.
=SUMIF('2’!$a:$a,”dog”,'2'!$b:$b)
=SUMIF('3’!$a:$a,”dog”,'3'!$b:$b)
and so on…
Thanks.
=SUMIF('1'!$a:$a,”dog”,'1'!$b:$b)
Is there a way to automate changing that sheet to “2,” then "3," ... for the next cells?
i.e.
=SUMIF('2’!$a:$a,”dog”,'2'!$b:$b)
=SUMIF('3’!$a:$a,”dog”,'3'!$b:$b)
and so on…
Thanks.