Quote:
Originally Posted by jensfrees
My knowledge in excel is rather basic, but I did figure out how to make a SUMIF function work. 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. This is my little formula - could anyone possibly help my out? Thanks in advance!
=SUMIF(A2:A70,"Brazil",G2:G70)
|
The easiest way is rather than typing the cell ranges in, use the mouse to select them. So type in =SUMIF( then use the mouse to select the range. If that hapens to be on a different worksheet or even in a different workbook, Excel will add the required symbols to the formula for you.