A challenge: referencing cell contents in a nested function formu

=?Utf-8?B?TmVlZHMgQXNzaXN0YW5jZQ==?=

Guest

Posts: n/a

28th Oct 2006

=SUM(IF(‘CS Invoices’!B5:B441=(CELL(“contents”,(A474+1)),‘CS
Invoices’!J5:J441))

What's wrong with this formula?

If possible, I do want to reference the prior cell (A474+1) so the formula
will update itself properly each time it is copied to a new row/cell.

HELP!

« How to assign a collection item? | Excel dropping decimal places »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I delete the contents of a cell without deleting the formu	6js59	Microsoft Excel Misc	0	3rd Jun 2008 07:01 PM
Excel VB or Macro. Referencing a cell by its contents.	arnezmando	Microsoft Excel Programming	1	22nd Nov 2006 03:27 PM
A challenge: referencing cell contents in nested function formula	=?Utf-8?B?TmVlZHMgQXNzaXN0YW5jZQ==?=	Microsoft Excel Worksheet Functions	3	28th Oct 2006 02:17 AM
Referencing the contents of a cell in Excell	=?Utf-8?B?SmVubg==?=	Microsoft Powerpoint	0	20th Apr 2006 11:36 PM
referencing cell contents, after deleting and shifting new contents into cell	HM	Microsoft Excel Misc	1	6th Feb 2004 10:56 PM