SUMIF Formula Help

handmadetsunami ✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am trying to work out how to do a a SUMIF formula but I can't get it to work.

I have a number of columns, one is a fee column (formatted as a Text/Number) and the other is a payment received column (formatted as a date). I have parent/child rows and want to perform this function on a parent row so it sums the children. If its not possible to do it as a sum of children, a sum of all the rows would work too as I need to work out the amount of fees we have taken year to date

I want to sum the fee column if there is a date in the payment received column to find the total amount of fees that have been paid. 

Please see attached screenshot of the columns.


Any help would be greatly appreciated 





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!