Concern with sum formula
Hello ,
Can you help me find out a formula in the " Cumulative Amount to Date " column , whose the result is the sum of data of another column from the first row to the row with the same number ?
Thanks in advance .
Answers
-
Assuming that you are looking for the value/result in the dark green cell in your screenshot above here is what may work,
=INDEX([Cumulative Amount to Date]:[Cumulative Amount to Date], COUNT([Cost / (Credit)]:[Cost / (Credit)])-1)
(For above to work you should not have any blank values in the Cost / (Credit) column between your first (aka row 2) and last row. In case there is no cost then default to 0 value)
-
Hi @Sameer Karkhanis thanks for your assistance . I will try tomorrow and I let you know .
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!