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.

Find more posts tagged with

Formulas

Comments

Mike Wilday

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

mmac

My apologies - oversight on my part.

Mike Wilday

This should do the trick for you...

=IF(Sum(children()) = 0 , "", sum(children())

mmac

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.

Mike Wilday

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

Mike Wilday

I am assuming that you are pre-populating 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()))

mmac

Worked great, thank you for your support!

Mike Wilday

Awesome! I'm glad I was able to help you out!

Sign in to join the conversation!

Quick Links

Trending discussions

Compare Previous Week
Hello, I am trying to be able to say whether hours went up or down as compared to the previous week but am having trouble referencing the previous week. I have tried to add a helper column but am still getting an error. Any help would be greatly appreciated!
SUMIFS Formula with Date Column
Hello All, I am using this formula " =SUMIFS({RCX- Kit Forecast - 2025 Range 1}, {RCX- Kit Forecast - 2025 Range 2}, ">=" + TODAY(), {RCX- Kit Forecast - 2025 Range 2}, "<=" + (TODAY() + 5)) " Range 1 is the number column Range 2 is a date column But the value is coming as zero
Workflow to trigger comms when number exceeded but not in between.
Hi, trying to work out how I can get a workflow to trigger only when certain milestone numbers are met. For example, I'd like an email comm to be sent once the sum of a column reaches 50, 100, 150, 200 etc. The number will be entered via a form, very basic, so for example 4 entries could be sent via 4 form inputs (15, 11,…