G
Guest
What I'm looking for is a way to sum the cells that contain =Ceiling.
I've tried SUMIF(range,"*CEILING*",range) but the formula returns 0. I'm
guessing it has to do with the fact that it is looking at the resulting value
of the cell instead of the formula.
Does anybody know if there is a way to have it search the formula?
Thanks in advance.
I've tried SUMIF(range,"*CEILING*",range) but the formula returns 0. I'm
guessing it has to do with the fact that it is looking at the resulting value
of the cell instead of the formula.
Does anybody know if there is a way to have it search the formula?
Thanks in advance.