Forum Discussion
Add to revenue if from a geographic location?
Something like this? Note Sheet2 would be the one newly created and Sheet1 the one you already have. I opted to use a simple SUMIF function.
Something like this? Note Sheet2 would be the one newly created and Sheet1 the one you already have. I opted to use a simple SUMIF function.
Yes! Exactly like that, thank you!!!!
Am I able to do this between 2 separate workbooks, not just sheets within the same workbook?
Yes, you are able to do so and making the references to the original workbook as long as they are both open. If this is a matter of one-time task, I would recommend that once you have it done, copy the results by the formulas on the new workbook and paste them as values, just to make sure you keep all the data. If you need to have it linked to the original workbook... then you are left to trust the connection doesn't break at any point in time.
- Thank you!
