1

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
  }
,"✓"
)

2020

2019

2018

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.