SUM Function

i need to add a row of numbers IF the 1st column is not blank as it contains a name. In other words, if there is a name in column 1, i need to total the numbers across the rest of the row. If column 1 is blank, no sum is needed.
Best Answer
-
Hello @GLW,
Try this:
=IF(NOT(ISBLANK([Primary Column]@row)), SUM([Column2]@row:[Column5]@row), "")
Hope that helps!
All the best,
-Ray
Answers
-
It sounds like you need a SUMIFS.
=SUMIFS([Column To Sum]:[Column To Sum], [Name Column]:[Name Column], @cell <> "")
-
Hello @GLW,
Try this:
=IF(NOT(ISBLANK([Primary Column]@row)), SUM([Column2]@row:[Column5]@row), "")
Hope that helps!
All the best,
-Ray -
Thanks Ray, worked well. I almost had it but missed the very first step! Been a long week, time for some single malt!
-
@GLW,
So glad it worked for you! Accept is as the answer if you don't mind. I know what you mean by a long week. Single malt, yum, you're talking my language!
Have a great weekend!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!