Sum works properly in the following instance:
=sum(j8:m120)
This sums all the values in between those two cells.
However in a sumif function:
=sumif(b8:b120,CONDITION,j8:m120)
I get some whacked out answer. It's not the sumer of the cells. Why does that (j8:m12) work in the sumif, but does work in the sum function?
Thanks
=sum(j8:m120)
This sums all the values in between those two cells.
However in a sumif function:
=sumif(b8:b120,CONDITION,j8:m120)
I get some whacked out answer. It's not the sumer of the cells. Why does that (j8:m12) work in the sumif, but does work in the sum function?
Thanks