SUMIFS formula that skips children rows and is based on YEAR and MONTH


I have a problem trying to make a formula work.

The sheet I want to take metrics from has a "value" column and a "date" column.

On some places in the "value" column there are Parent rows that sums the children rows.

I want to make a SUMIFS formula that can Sum the total Value based on YEAR and MONTH but not SUM children rows since the Children rows are summed up in the Parent Row.

Anyone know how to? :D

Kind Regards,

Hugo Martinwall


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!