Hi there - I'm a very beginner-intermediate Excel user as far as formulas go - I don't know most of the technical verbiage, nor what most of the formula handles (that's what they're called, right?) even mean, let alone what they do. I can basically figure things out as I go by finding examples on different forums, etc, but I've run across a seemingly very simple problem that for the life of me I can't figure out.
I have an array formula that I need to copy down the entire column. The formula is: =SUM(IF(IF(K$2>=V3:V5,V3:V5-V2:V4,$K$2-V2:V4+1)>0,IF(K$2>=V3:V5,V3:V5-V2:V4,$K$2-V2:V4+1),0)*W2:W4)
I need the Row values to change, not the "array formula parts" (because I don't know what they really are called). So, as I copy down I need the new formula to read: =SUM(IF(IF(K$4>=V3:V5,V3:V5-V2:V4,$K$4-V2:V4+1)>0,IF(K$4>=V3:V5,V3:V5-V2:V4,$K$4-V2:V4+1),0)*W2:W4)
The only way I've been able to do that is to rewrite the whole formula in the new row cell. Please tell me there's a better way!
Bookmarks