Thread: A challenge: referencing cell contents in a nested function formu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Needs Assistance[_2_] Needs Assistance[_2_] is offline
external usenet poster
  
Posts: 1
Default A challenge: referencing cell contents in a nested function formu
=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!
Reply With QuoteReply With Quote