ExcelBanter - A challenge: referencing cell contents in a nested function formu

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - A challenge: referencing cell contents in a nested function formu (https://www.excelbanter.com/excel-programming/376165-challenge-referencing-cell-contents-nested-function-formu.html)

Needs Assistance[_2_]

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!

All times are GMT +1. The time now is 08:46 PM.