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 that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.