SOLVED

Need help retrieving data from table and adding it to one of 8 variables

Copper Contributor

I need help getting the totals from this:

Dylan03_0-1674486804945.png

And adding it to this:

Dylan03_1-1674486922201.png

I'm able to get it to add one total of each variable, however I don't know enough about excel to add more data, from a table, to that variable.

Dylan03_2-1674487759198.png

If anyone could help, that would be greatly appreciated.

3 Replies

@Dylan03 

 

From your description, it sounds very much like a job for the SUMIF function. That link will take you to a site that explains how to use it. 

 

If that's insufficient assistance, may I suggest you post a copy of the workbook(s) from which you took the images--the actual workbook(s)--on OneDrive or GoogleDrive, and paste a link here granting edit access to the real thing. Images are good, but access to a real spreadsheet is more helpful still.

best response confirmed by Dylan03 (Copper Contributor)
Solution

Hi @Dylan03 

 

looking at your table setup, the easiest way would be using a Pivot table. Just select the source table and then goto menu "Insert | PivotTable"

Martin_Weiss_0-1674488588015.png

You can place it on a new worksheet or on the existing one:

Martin_Weiss_1-1674488663675.png

Then just drag and drop the PivotTable Fields:

Company to the rows

Rate to the columns

Total to the values

Martin_Weiss_2-1674488892822.png

 

And that's it.

 

You only need to refresh the Pivot table with a right-click and "Refresh" whenever new records are added to the source table:

Martin_Weiss_3-1674488958945.png

 

Thank you so much, it worked and was easy to understand for my 2am brain. Much appreciated
1 best response

Accepted Solutions
best response confirmed by Dylan03 (Copper Contributor)
Solution

Hi @Dylan03 

 

looking at your table setup, the easiest way would be using a Pivot table. Just select the source table and then goto menu "Insert | PivotTable"

Martin_Weiss_0-1674488588015.png

You can place it on a new worksheet or on the existing one:

Martin_Weiss_1-1674488663675.png

Then just drag and drop the PivotTable Fields:

Company to the rows

Rate to the columns

Total to the values

Martin_Weiss_2-1674488892822.png

 

And that's it.

 

You only need to refresh the Pivot table with a right-click and "Refresh" whenever new records are added to the source table:

Martin_Weiss_3-1674488958945.png

 

View solution in original post