Help with a SUMIF Formula please

MickiSather

Can someone help with me with an entire column formula so that I don't have to manually click through 25,000 rows of data? I would like the "Transaction Amount" column added and put in the "Total Client Revenue" column IF the "Transaction Type" column says 'payment'.

Julie Fortney

Try this in the Total Client Revenue column:

=IF([Transaction Type]@row="Payment", [Transaction Amount]@row)

MickiSather

Hi Julie, thank you so much for the formula you provided! Is there a formula that would then add those totals and put them in the red row for each client under the "Total Client Revenue" Column?

Julie Fortney

Try this in the Total Client Revenue column:

=IF([Transaction Type]@row="Payment", [Transaction Amount]@row)

MickiSather

Hi Julie, thank you so much for the formula you provided! Is there a formula that would then add those totals and put them in the red row for each client under the "Total Client Revenue" Column?

MickiSather

Ooooh- wait, I think I found it! If I collapse all parent rows and put =SUM((children))!!!

Julie Fortney

Awesome!!