Only pick up cells with numbers in already complex formula

[gcuddy]

Hi all.

I'm using this formula to calculate the number of cells it takes a row to get to a certain number and its working well.
=MATCH(TRUE,INDEX(SUMIF(OFFSET(D2,,,,COLUMN(D2:AN2)-COLUMN(D2)+1),"<>0")>=2099,0),0)

Now I want to specify the formula to only pick up cells in that row that contain numbers.

I'd appreciate any help.

Thanks
G

[:) Sixthsense :)]

Instead of posting your formula and asking us to edit it please explain what you are doing with it and now what is the current requirement for better understanding

[gcuddy]

I need to find out how many cells in a row add up to a certain number. However some of these cells at the beginning of the row can be empty and I don't want to count those.

Please see the attached example. (cant figure out how to put in the post effectively.)

Let me know if you need any more.

[:) Sixthsense :)]

Thanks for the attachment but please explain on what basis you are arriving the values in AN column for better understanding.