Is there an elegant—more programatic way—to count across sheets based on some criteria like whether they have been checked.
For example, given the attached sheets, the result would be:
Apples: 1
Oranges: 2
Watermelon: 1
The best formula I could come up with is :
=COUNTIFS(
{
'2020'!A:A;
'2019'!A:A;
'2018'!A:A
}
,A1,
{
'2020'!B:B;
'2019'!B:B;
'2018'!B:B
}
,"✓"
)