COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet

		Microsoft Office Forums > Microsoft Excel > Excel
COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet

10-24-2016, 10:33 PM

xor

Windows 10 COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

On second thought I don't think my suggestion works. I guess you have something in between BC3 and BE3, BE3 and BK3 and so on?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open an existing sheet by clicking on a cell in a master sheet	darbybrown	Excel	3	09-12-2016 05:12 PM
Find text within cell and return column and row title next to the name on a new sheet.	tanyabowring@live.co.uk	Excel Programming	2	03-26-2015 01:48 AM
COUNTIF and Cell address problem	ColinC	Excel	3	12-24-2011 04:08 AM
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
Excel sheet references in Word	ilkks	Word	2	05-16-2011 03:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.