Dear Seniors,
I am new user to VBA & had created a Array sum product formula with multiple conditions and it works fine. Now I would like to get help from this forum to create the same formula in Excel VBA. Presently I am using named ranges in my formula. But I would like to use the formula by selecting the dynamic ranges.
Here is the formula I am using to calculate my result based on the Date in C1
{=SUMPRODUCT(IF(((INTPLANIFD>0)*(INTPLANIFD<=H$32)),1,IF(((INTPLANIFA>0)*(INTPLANIFA<=H$32)),0.8,IF(((INTPLANIFR>0)*(INTPLANIFR<=H$32)),0.6,0)))*(INTWF))}
where us INTPLANIFD, INTPLANIFA, INTPLANIFR are Named ranges which contains Dates & INTWF is a Number.
Actually I am using this formula to calculate the progress on a particular date.
Could you please assist me to create the formula. Herewith I had enclosed the sample file, In sheet named "CURVE" I am using this formula.
Thanks and Regards
R. Vadivelan
I am new user to VBA & had created a Array sum product formula with multiple conditions and it works fine. Now I would like to get help from this forum to create the same formula in Excel VBA. Presently I am using named ranges in my formula. But I would like to use the formula by selecting the dynamic ranges.
Here is the formula I am using to calculate my result based on the Date in C1
{=SUMPRODUCT(IF(((INTPLANIFD>0)*(INTPLANIFD<=H$32)),1,IF(((INTPLANIFA>0)*(INTPLANIFA<=H$32)),0.8,IF(((INTPLANIFR>0)*(INTPLANIFR<=H$32)),0.6,0)))*(INTWF))}
where us INTPLANIFD, INTPLANIFA, INTPLANIFR are Named ranges which contains Dates & INTWF is a Number.
Actually I am using this formula to calculate the progress on a particular date.
Could you please assist me to create the formula. Herewith I had enclosed the sample file, In sheet named "CURVE" I am using this formula.
Thanks and Regards
R. Vadivelan