Have the SUMIF result (formula) on a separate sheet/tab

[jensfrees]

My knowledge in excel is rather basic, but I did figure out how to mak
a SUMIF function work. My problem is that I can only make it work when
keep the formula on the same sheet where the numbers are. I would lik
it to be on a second tab (sheet). I have tried to insert Sheet1!, but i
does not work. This is my little formula - could anyone possibly help m
out? Thanks in advance!

=SUMIF(A2:A70,"Brazil",G2:G70

 

[joeu2004]

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)

 

[Spencer101]

My knowledge in excel is rather basic, but I did figure out how to mak
a SUMIF function work. My problem is that I can only make it work when
keep the formula on the same sheet where the numbers are. I would lik
it to be on a second tab (sheet). I have tried to insert Sheet1!, but i
does not work. This is my little formula - could anyone possibly help m
out? Thanks in advance!

=SUMIF(A2:A70,"Brazil",G2:G70)

The easiest way is rather than typing the cell ranges in, use the mous
to select them. So type in =SUMIF( then use the mouse to select th
range. If that hapens to be on a different worksheet or even in
different workbook, Excel will add the required symbols to the formul
for you