MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Leah    Date: Feb 18    Category: MS Office    Views: 485

How does vba sumproduct work when the range isn't fixed but instead
should be able to change.



3 Answers Found

Answer #1    Answered By: Fahmida Ahmed     Answered On: Feb 18

Much more information please.

Answer #2    Answered By: Vidhya Iyer     Answered On: Feb 18

Use a dynamic named range..........

Answer #3    Answered By: Cyka Jansen     Answered On: Feb 18

Keep in mind that the only restriction on SumProduct() is that all the range(s)
or Array(s) in each of the function components must be the same 'size' (or
length of contiguous cells). I don't see an issue with the 'dynamic' part as
long as the 'size' part is satisfied.

Didn't find what you were looking for? Find more on sumproduct Or get search suggestion and latest updates.