Same Column - Row Type Header = Sum value of Row Type Detail

Based on the image below

There are two Row Type: (1) Header and (2) Detail.

JE REPORT is the grouping of these records.

AMT = free form data entry

Debit = if(AMT>0, AMT, 0)

Credit = if(AMT<0, AMT,0)


I want to sum Row Type = Header for all Detail rows of the same JE REPORT.

The first row would sum of RowNum 00074 - 00087, so the value of DEBIT would be $9,502.00 and CREDIT would be = -$9,502.00.

Is this possible?

Thank you

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!