VBA Sumif cell is a number

[kitkatjam]

I am trying to sum a range, say column A, but only if the corresponding row in column B is a number. Column B contains either numbers or "". I can't figure out how to say it.

Sumifs(Range(A:A), Range(B:B), IsNumeric) was my first attempt but didn't work. Any help would be greatly appreciated, thank you!

 

[Joe4]

Just use ">0" for your criteria.
By the way, since there is only one conditions, SUMIF will do. No reason to need SUMIFS, i.e.

=SUMIF(B:B,">0",A:A)

 

[Fluff]

How about
=SUMIF(B2:B15,"<>*",A2:A15)

 

[kitkatjam]

The problem is the "" come back as >0. Even though it's not a number, it's returning >0 = True so it ends up summing everything

 

[kitkatjam]

This worked, thank you!!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Joe4]

The problem is the "" come back as >0. Even though it's not a number, it's returning >0 = True so it ends up summing everything

Hmmm...
It doesn't do that for me.

 

[Fluff]

Using >0 works for me as well, as long as none of the values in col B are negative.
In fact >0 still works for me if the formula returns " " rather than "" in col B