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

4

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.