Help with a SUMIF Formula please
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'.
Best Answers
-
Try this in the Total Client Revenue column:
=IF([Transaction Type]@row="Payment", [Transaction Amount]@row)
-
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?
Answers
-
Try this in the Total Client Revenue column:
=IF([Transaction Type]@row="Payment", [Transaction Amount]@row)
-
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?
-
Ooooh- wait, I think I found it! If I collapse all parent rows and put =SUM((children))!!!
-
Awesome!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!