How to convert formula to RC style using in macro recording

[Useful]

Hi! everybody
Now i faced the problem: to convert the formula RC style using macro recording
P.S:At home i using 2007 and with 2007 it is possibe with coping and pasting the formula i can get the result that i want)
but now just a moment i use 2003 and appear unable to record macro when tring record macro. My formula is too long. When converting short formula it is working
My formula is below:

=SUMIF(K8:OFFSET(K8;IF(ISBLANK(E7);"";IF(MAX(E:E)=E7;COUNTA(F8:$F$1000);MATCH(E7+1;E7:$E$1000;0)-4));0);"Ok";F8:OFFSET(F8;IF(ISBLANK(E7);"";IF(MAX(E:E)=E7;COUNTA(F8:$F$1000);MATCH(E7+1;E7:$E$1000;0)-4));0))

Thanks in advance!

 

[jasonb75]

Try

=IF(E7="";"";SUMIF(OFFSET(K8;;;IF(MAX(E:E)=E7;COUNTA(F8:$F$1000);MATCH(E7+1;E7:$E$1000;0)-4));"Ok";F8:$F$1000))

as an alternative.

 

[Useful]

Try

=IF(E7="";"";SUMIF(OFFSET(K8;;;IF(MAX(E:E)=E7;COUNTA(F8:$F$1000);MATCH(E7+1;E7:$E$1000;0)-4));"Ok";F8:$F$1000))

as an alternative.

Hi! Thanks for your answer but this formulas isn't as alternative (i have checked) are there another way to convert this formula to RC style?
(now formula is in "K7")

 

[jasonb75]

You can convert any formula to R1C1 but because you're doing it with excel 2003 you are limited to 7 nested functions.

Where is it differing from your original formula?

 

[Useful]

You can convert any formula to R1C1 but because you're doing it with excel 2003 you are limited to 7 nested functions.

Where is it differing from your original formula?

jasonb75 now i can't to check it step by step but i controlled both formulas but result isn't equal at everywhere (This formula should to start from "K7" in my example)
is it right to convert this formula as separate and then to join them?

 

[jasonb75]

jasonb75 now i can't to check it step by step but i controlled both formulas but result isn't equal at everywhere (This formula should to start from "K7" in my example)
is it right to convert this formula as separate and then to join them?

I don't think that will work, you will still exceed the 7 function limit when you join it.

Can you post some sample data from your sheet so I can compare the results, everything I'm trying gives the same result from both.

 

[Useful]

I don't think that will work, you will still exceed the 7 function limit when you join it.

Can you post some sample data from your sheet so I can compare the results, everything I'm trying gives the same result from both.

I'm sorry about trouble i've changed this part and it works

=SUMIF(K8:OFFSET(K8;IF(ISBLANK(E7);"";IF(MAX(E:E)=E7;COUNTA(F8:$F$1000);MATCH(E7+1;E7:$E$1000;0)-4));0);"Ok";F8:F100)

(reduced sum range)

Thanks!