COUNT IF formula
Hello,
I've read through a couple of different examples, but I am not having any luck.
I am looking to have the # Assets count total displayed in the highlighted parent row/cell based on the following criteria.
If # assets cell below the parent is greater than 0 for the total count to display.
Comments

Can you share a screenshot? It would be extremely helpful for understanding what you mean.

My apologies  oversight on my part.

This should do the trick for you...
=IF(Sum(children()) = 0 , "", sum(children())

Thank you for the reply!
Unfortunately, not working as expected. Here is a video example if at all helpful.
https://www.loom.com/share/f28346c4cc76434bb6dd6cf3a6c983e9
Row 1 is parent row 
# Assets should count ALL cells below it in the same column if greater than 0.
Rows 3  8 would = 1 for example under # Assets and then row 2 would count the children below it as 6 total assets.
Row 1 would count all assets of the subset of children under US and in the example would equal to 6.
And CA/AU would be the same concept. CA # of assets would be counted in row 9 and AU under row 16. Those total counts would roll up into the total # of assets in row 1.

As long as you put the formula in all the parent rows it should work properly. Please review my screenshot showing the working data...

I am assuming that you are prepopulating the base rows with 1.
If not, try this formula in every row... This will populate a 1 in every base child row and sum the counts of the immediate children if it is a parent row.
=IF(SUM(CHILDREN()) = 0, 1, SUM(CHILDREN()))

Worked great, thank you for your support!

Awesome! I'm glad I was able to help you out!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!