Formula adding from 2 sheets

Question

What formula would I use to add 2 sets of data from the same workbook and same sheet, but using a formula in a different sheet to add the total of referrals for each base. I want to be able to convert the data to a chart/graph and for the chart/graph to update automatically when data is entered into the first sheet.

Answer 1

Hi,

We need to see sample data and the formulas you currently are using. And we need to know what you expect a answers based on your sample data.

If you were building the formulas on the same sheet as the data what would they read?

For example =A1+D1

Then on a different sheet the formula would read:

=Sheet4!A1+Sheet4!D1

Where the original data is on Sheet4.

Answer 2

Hello Ceri,

Unfortunately, I don't have any further troubleshooting to offer.

There are many knowledgeable users active on the forum and I hope that someone else can offer further insight into your issue.

Thanks IBHADIGHI

Answer 3

Hi

It comes up with a value error?

Basically I have a tab called ‘data analysis’ with all names, bases and D.O.B. Then on another sheet I want the tab called ‘base’ on the tab called base, I want to be able to calculate all of the bases and how many people are allocated to that base. I want to create a chart on these results on tab ‘base’ I want this to automatically update when data is entered on the tab called ‘data analysis’

Answer 4

Hello Ceri,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

You can use the SUM formula to add two sets of data from the same workbook and sheet, but using a formula in a different sheet. For example, if you have data in Sheet1 in cells A1:A10 and B1:B10, and you want to add the total of these two sets of data in Sheet2, you can use the following formula in Sheet2:

=SUM(Sheet1! A1:A10) + SUM(Sheet1! B1:B10)

This formula will add the values in cells A1:A10 and B1:B10 in Sheet1 and display the result in the cell where you entered the formula in Sheet2.

To create a chart or graph based on this data, you can select the cell with the formula result and then insert a chart or graph. The chart or graph will automatically update when data is entered into Sheet1.

Please let us know if you need more help.

Best Regards, IBHADIGHI