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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!