I have a spreadsheet with a column i need to summarize by source but with the total of each source. Also if the source changes i want the summary to change to either add that new source or change it. Any ideas would be great.
I have a spreadsheet with a column i need to summarize by source but with the total of each source. Also if the source changes i want the summary to change to either add that new source or change it. Any ideas would be great.
conano7o,
To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.
The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.
To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Ok i attached the document for you called sample.xlsx. The desired results are a summary of whatever data is entered in Source. But i dont want to have to type in the the desired results source. i want to be able to type in the source in the spreadsheet then it show up in the results column with totals that update depending on if i enter the same source twice.
conano7o,
Detach/open workbook Unique Sorted Text List and Count - conano7o - EF769659 - SDG15.xlsx and make additions/deletions to range J2:J26.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks