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

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-24-2016, 11:44 AM

Helix2

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

Office 2016

Novice

Join Date: Oct 2016

Posts: 3

Thank you xor. I don't fully understand the criteria that decides if a cell gets taken and put into the continuous range (I have only recently learnt how to use INDEX) so I will experiment with it when I get home from work.

Thanks again for your help.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:14 AM.