Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SumIF Formula
Below is the formula I am using - is there a way to make the formula look at
$E:$E and $K:$K instead of defining a specific range? =SUMIF('[2005 Totals.xls]2005 Sales'!$E$2:$E$38,"IM-natl",'[2005 Totals.xls]2005 Sales'!$K$2:$K$38) |
#2
|
|||
|
|||
You didn't want to try it before you asked? Yes SUMIF can use the whole range,
since your formula isn't in the same workbook as the one you are getting information from, remember that both workbooks need to be open Regards, Peo Sjoblom "Erika" wrote: Below is the formula I am using - is there a way to make the formula look at $E:$E and $K:$K instead of defining a specific range? =SUMIF('[2005 Totals.xls]2005 Sales'!$E$2:$E$38,"IM-natl",'[2005 Totals.xls]2005 Sales'!$K$2:$K$38) |
#3
|
|||
|
|||
I did try it and I got the Num error - that is why I was asking.
"Peo Sjoblom" wrote: You didn't want to try it before you asked? Yes SUMIF can use the whole range, since your formula isn't in the same workbook as the one you are getting information from, remember that both workbooks need to be open Regards, Peo Sjoblom "Erika" wrote: Below is the formula I am using - is there a way to make the formula look at $E:$E and $K:$K instead of defining a specific range? =SUMIF('[2005 Totals.xls]2005 Sales'!$E$2:$E$38,"IM-natl",'[2005 Totals.xls]2005 Sales'!$K$2:$K$38) |
#4
|
|||
|
|||
This will work
=SUMIF('[2005 Totals.xls]2005 Sales'!$E:$E,"IM-natl",'[2005 Totals.xls]2005 Sales'!$K:$K) You can get a value error if [2005 Total.xls] is closed -- Regards, Peo Sjoblom (No private emails please) "Erika" wrote in message ... I did try it and I got the Num error - that is why I was asking. "Peo Sjoblom" wrote: You didn't want to try it before you asked? Yes SUMIF can use the whole range, since your formula isn't in the same workbook as the one you are getting information from, remember that both workbooks need to be open Regards, Peo Sjoblom "Erika" wrote: Below is the formula I am using - is there a way to make the formula look at $E:$E and $K:$K instead of defining a specific range? =SUMIF('[2005 Totals.xls]2005 Sales'!$E$2:$E$38,"IM-natl",'[2005 Totals.xls]2005 Sales'!$K$2:$K$38) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify SumIF... Array Formula | Excel Worksheet Functions | |||
Standard sumif formula not recognised | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |