| 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) |
| 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 | |||
Threaded Mode
