Sumif
Posted by Don Reynolds on December 12, 2000 7:50 AM
Can Sumif use a variable in the sum-range? I am using a forumla like sumif(b:b,a1,c:c), where I am trying to find every occurance of a1 in column b, and add the totals in colums c. The problem is I want to have the sum-range reference a variable so I can sum column d,e,f,g or whatever by simply changing a reference cell. I expect it would be something like Sumif(b:b,a1,a3), where cell a3 states the column c:c or d:d, etc. I can't get it. Thanks