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-25-2016, 03:20 AM

cobbe

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

Office 2016

Novice

Join Date: Mar 2016

Posts: 6

Use a namedefinition for de used cells.

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 09:21 AM.