SUMIF Formula Help
Hi
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
Comments
-
Hi,
Try something like this.
=SUMIF(CHILDREN([Payment Received Date]@row); ISDATE(@cell); CHILDREN(Fee@row))
The same version but with the below changes for your and others convenience.
=SUMIF(CHILDREN([Payment Received Date]@row), ISDATE(@cell), CHILDREN(Fee@row))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
That works perfectly! Thank you so much, the formulas I had tried were nowhere near right!
Kind regards
-
Excellent!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!