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.

Find more posts tagged with

Accepted answers

dojones

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.

All comments

dojones

Carolyn H

OK, thank you dojones - much appreciated

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.