M
Michael
I am looking for an easy way to set whole column of formuals to one
formula if cell a1 = "sum" and another formula if a1 = "count"
is there a way to use indirect to do something like this. I cant seem
to get it to work.
formulas in cells below would end up being either
=sum(b2:z2)
=sum(b3:z3)
and so on or
=count(b2:z2)
=count(b3:z3)
bascily I just want to swap out the function. the fuctions I am using
are both UDFs but each one only takes one reference
Any help would be apprecated.
formula if cell a1 = "sum" and another formula if a1 = "count"
is there a way to use indirect to do something like this. I cant seem
to get it to work.
formulas in cells below would end up being either
=sum(b2:z2)
=sum(b3:z3)
and so on or
=count(b2:z2)
=count(b3:z3)
bascily I just want to swap out the function. the fuctions I am using
are both UDFs but each one only takes one reference
Any help would be apprecated.