LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Cell value in a formula -- Indirect function? Help please...

Hello all, need some help. I want to use the cell output in the
formula. There are two outputs from the secondary worksheet in the D
and H columns. A month and a number. They are if then formulas
though, on the secondary worksheet, based on other cells in that
secondary sheet.

I have the following formula on my primary sheet:

=SUMIF(Ret_Rate_Worksheet!D10:D109,"January",Ret_R ate_Worksheet!H10:H109)

On the Ret_Rate worksheet, the 'January' value is a calculated value
and the value in the H column is also a calculated value. What should
my formula look like for it to work? If I manually type in January in
the D field and some numbers in the H field, the formula works.
However, I want excel to use the 'value' or output/result on the other
worksheet in the formula I have on my other worksheet. I think I need
to use the indirect function??? Help please...

-Rob
 
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
Copying a formula containing the INDIRECT function Pelham[_2_] Excel Worksheet Functions 7 August 30th 09 06:54 AM
Name of named formula used in an INDIRECT function Werner Rohrmoser Excel Worksheet Functions 4 August 21st 08 11:19 AM
Cell reference OR INDIRECT function Excel ESG Excel Worksheet Functions 2 June 11th 07 11:26 AM
Can INDIRECT function reference a cell that contains a formula Steve E Excel Worksheet Functions 13 August 23rd 06 10:49 PM
include INDIRECT function into SUMPRODUCT formula markx Excel Worksheet Functions 1 November 9th 05 05:04 PM


All times are GMT +1. The time now is 02:00 AM.

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

About Us

"It's about Microsoft Excel"