Thread: how to insert a collum on a sheet without it changing cell referen
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how to insert a collum on a sheet without it changing cell ref
If that's the case, maybe just grab the entire row 3 then?
=COUNTIF(INDIRECT("'Numbers'!3:3"),1)
--
Max
Singapore
---
"Just Me" wrote:
OK i will experiment with:
=COUNTIF(INDIRECT("'Numbers'!A3":AE3),1)
because the :AE3 part of the range needs to change as I populate the Numbers
sheet.

Reply With QuoteReply With Quote