LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 44
Default INDIRECT Follow On

Following on (hopefully you can help me Ardus)

I can't get it to work in context

If in cell AF3 is 0703

currently the formula below is
=SUMPRODUCT(('[Incidents period0703.xls]DATA'!$G$8:$G$2000=$C8)*('[Incidents
period0703.xls]DATA'!$W$8:$W$2000="Mainline"))

but how can I change this formula to depend on the contents of AF3?

ie if AF3 was 0704 the formula would read
=SUMPRODUCT(('[Incidents period0704.xls]DATA'!$G$8:$G$2000=$C8)*('[Incidents
period0704.xls]DATA'!$W$8:$W$2000="Mainline"))

Many thanks in advance
 
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
Define chart range using indirect reference Thomas Charts and Charting in Excel 3 May 10th 06 09:44 PM
INDIRECT - Strange behavior vezerid Excel Discussion (Misc queries) 5 April 19th 06 12:52 PM
Copying a formulae down a column that includes an INDIRECT A.Webb Excel Discussion (Misc queries) 10 January 14th 06 03:42 AM
Using the Indirect function with a sheet number instead of a sheet name JDB Excel Worksheet Functions 5 December 31st 05 03:03 PM
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM


All times are GMT +1. The time now is 11:17 AM.

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"