Thread: [Solved] COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet
View Single Post
 
Old 10-24-2016, 09:57 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
It takes up to and including the last cell in BC3:BZ3 containing a number. You can change BZ3 to a higher address if needed.

Please note that the formulas in BC1:BZ1 are array formulas. An array formula must be entered by holding down Ctrl and Shift before pressing Enter where you normally just press Enter. If you do it correct Excel will automatically put braces {} around the formula. When you have entered one array formula correctly you can copy it to other cells in the normal way.
Reply With Quote