google sheets
I would like to make the sum of a column which might also contain cells which are not parseable as a number (strings, empty, etc). These cells should just be ignored.
I've tried:
=SUMIF(A1:A500,"<>0")
but it doesn't work because it also seems to exclude cells which actually contain valid numbers.
Is there a better way of performing a summation, excluding none parseable values?
Use the following formula to accomplish that.
=QUERY(
'GR Live Campaign Tracker'!J:L, // data range
"SELECT J, COUNT(L) WHERE L IS NOT NULL GROUP BY J", // select
0 // headers
)
Added the formula into your example file.
If I understood correctly, a combination of filter (which filters out the empty cells, keeping only the non-blank cells) and transpose, should work:
=transpose(filter(B2:2, len(B2:2)))
Best Answer
Let me add my comment as an answer... :-)
You should be okay just using =SUM(), because sum() simply ignores non-numeric values.