Forum Discussion
SUMIF returning 0
Hi, I am using the sumif function on data that already has formulas within the cells (sum-range) which i think is tripping up the sumif formula and returning zero. Example. I am trying to sum de...
As variant formulae in column J return texts which looks like numbers, not numbers. For example, =LEFT("2a") returns text "2", not number 2. To have the number we may use =1*LEFT("2a")
Perhaps something else, it's hard to say without sample file or at least screenshot.
Ah amazing that has worked thank you so much I was wracking my brain!
AliceH2265 , you are welcome