Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying a formula containing the INDIRECT function | Excel Worksheet Functions | |||
Name of named formula used in an INDIRECT function | Excel Worksheet Functions | |||
Cell reference OR INDIRECT function | Excel Worksheet Functions | |||
Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions |