Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Indirect In formulas

Apologies for not making myself clear.

I am using a macro to populate column A with the names of all the worksheets in the workbook onto a sheet called Summary

I then want to use the names of the worksheets in a COUNTIF statement

so rather than =COUNTIF(G12:G889,"text")

I want to COUNTIF(INDIRECT("'" & Summary!A18 & "'!" & "A23"):=INDIRECT("'" & Summary!A18 & "'!" & "A24"),"text") whe

Summary!A18 is the other worksheet name and A23 and A24 are the neginnings and ends of the range.

Is that clearer?

Thanks in advance




--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Indirect In formulas

Hi,

Am Sun, 6 Oct 2013 14:09:23 +0100 schrieb no_name:

Summary!A18 is the other worksheet name and A23 and A24 are the neginnings and ends of the range.


if A23 and A24 are into the same sheet as your formula then:
=COUNTIF(INDIRECT("'"&Summary!A18&"'!"&A23&":"&A24 ),"text")

If A23 and A24 are also into sheet "Summary" then:
=COUNTIF(INDIRECT("'"&Summary!A18&"'!"&Summary!A23 &":"&Summary!A24),"text")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow Excel Worksheet Functions 7 May 21st 23 07:42 PM
Indirect formulas in cells not holding cell format after copy Cathy[_3_] Excel Worksheet Functions 3 March 21st 10 06:39 AM
Indirect ref in array formulas RD Wirr Excel Worksheet Functions 3 November 18th 06 02:17 PM
Multiple formulas including INDIRECT Gizmo Excel Worksheet Functions 4 December 21st 04 08:07 PM
using INDIRECT in array formulas Steven Stovall Excel Programming 2 December 3rd 04 12:01 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"