Hi, I'm a new excel user and could use some help. I'm trying to get a SUM for an array that looks like this:
DxPQicx.png
I've tried several different variations of SUMIF such as:
{=SUMIF(Q9:Q19,"<>"&"-")} returns 0
{=SUMIF(Q9:Q19,"+*"} returns 0
Using (Q9:Q19)*1 instead of (Q9:Q19) gives me a syntax error. Any help would be greatly appreciated. Thank you.
Bookmarks