hi Rob
One question regarding the calculated values in column D: Are they text
values or dates. From your description I ssume you have calcualted
dates (and formated them to show only the month). Maybe you can post
your formula in column D and some example data

Frank

Rob B wrote:
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:H10
9)

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