Total "Calculated Total Amount:" column values for all previous matching "CWID"s on same sheet
I have a sheet that collects data from user applications for funding. Unique users are identied by a "CWID" number and the amount of funds they're asking for is in the "Calculated Total Amount:" column at that row.
Whenever a new application comes in I want it to search the (same) sheet for earlier entries from the same CWID and if there are any, to sum the "Calculated Total Amount:" value(s) from those rows. I.e. I want it to tell me how much money, total, that person has previously requested on the sheet.
I'd like for it to calculate the total right there on the sheet rather than on a separate report page.
I'm guessing it's probably very simple but I've tried all sorts of SUMIFs and VLOOKUPS and INDEX and not getting anywhere. Any help would be super appreciated.
Best Answer
-
I think you will have to perform the calculation on a separate sheet for total funds by CWID, but you can then display the total funds for the CWID on the data collection sheet using a vlookup from the summary sheet.
Answers
-
I think you will have to perform the calculation on a separate sheet for total funds by CWID, but you can then display the total funds for the CWID on the data collection sheet using a vlookup from the summary sheet.
-
OK, thank you dojones - much appreciated
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!