COUNTIF CHILDREN in the Sheet Summary

Aliaksandr Ilyuk

Hi!

I am trying to count the number of projects for each country in the Sheet Summary menu to use that values on a dashboard. I know how to use COUNTIF and CHILDREN in cells, but I can't figure out how to use this combination in the Sheet Summary menu. Here is my screenshot:

Help, please!

Paul Newcome

Try this...

=COUNT(CHILDREN(Country1))

Paul Newcome

Try this...

=COUNT(CHILDREN(Country1))

Aliaksandr Ilyuk

Thank you a lot! It's so simple 😀

The root of the problem was that I was trying to reference the cell Country1, but had to reference Project1.

Paul Newcome

Happy to help. 👍️