|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 17th, 2006, 02:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a sum when looking up two different values
=SUM(IF('[Mar 06 Sales 1.xls]Pernod'!$A$1:$A$7320,A7)+('[Mar 06 Sales
1.xls]Pernod'!$G$1:$G$7320,AC4),'[Mar 06 Sales 1.xls]Pernod'!$K$1:$K$7320) I can not get this formula to return an result. I can only get a "Value" answer. What am I doing wrong? 
|
|
#2
April 17th, 2006, 02:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a sum when looking up two different values
Your IF function requires non-array arguments
HTH -- AP "1stcoast" a écrit dans le message de ... =SUM(IF('[Mar 06 Sales 1.xls]Pernod'!$A$1:$A$7320,A7)+('[Mar 06 Sales 1.xls]Pernod'!$G$1:$G$7320,AC4),'[Mar 06 Sales 1.xls]Pernod'!$K$1:$K$7320) I can not get this formula to return an result. I can only get a "Value" answer. What am I doing wrong?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Large Function returning top values | J Shrimps, Jr. | Worksheet Functions | 8 | March 31st, 2006 04:02 AM |
| Looking up data in a column, then returning values of respective row | TC | General Discussion | 4 | March 22nd, 2006 02:47 PM |
| Returning an answer in an if fuction between two values | Nat | Worksheet Functions | 1 | June 2nd, 2005 01:33 PM |
| Returning multiple values from a function... | Brad Pears | Using Forms | 6 | November 9th, 2004 07:59 AM |
| Returning multiple values from user worksheet function | Michael Hlavinka | Worksheet Functions | 2 | February 5th, 2004 08:09 PM |
Linear Mode
