LinkBack URL
About LinkBacks
In the attached workbook, this formula is in C3Using the same formula in D3 but targeting F$22 instead of H$22. Why won't this work? It must be so obvious I can't see it. Any help with this issue would be greatly appreciated!HTML Code:
Sick
In the attached workbook, this formula is in C3Using the same formula in D3 but targeting F$22 instead of H$22. Why won't this work? It must be so obvious I can't see it. Any help with this issue would be greatly appreciated!HTML Code:
Sick
Hi,
You'll need to get rid of the circular references in column F before the formula will work. Note that you don't need to enter a SUMPRODUCT formula with CTRL, SHIFT and ENTER - it's treated as an array without.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There we go!
Thanks sweep!
Sick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks