Have the SUMIF result (formula) on a separate sheet/tab
"jensfrees" wrote:
My problem is that I can only make it work when I
keep the formula on the same sheet where the numbers
are. I would like it to be on a second tab (sheet).
I have tried to insert Sheet1!, but it does not work.
[....]
=SUMIF(A2:A70,"Brazil",G2:G70)
Since you do not show how you inserted Sheet1, we cannot tell you what you
did wrong. Try:
=SUMIF(Sheet1!A2:A70,"Brazil",Sheet1!G2:G70)
|