Sumif not blank

[par60056]

I know this is easy and I just can't find the right way.

I want to sum J if C is not blank.

I know I can sum it is it IS blank with:
=sumif(C1:C1000,"",J1:j1000)

But I can't figure out how to specify the condition <>""

 

[Jonmo1]

Try

=SUMIF(C1:C1000,"<>",J1:J1000)


However, this only works for TRUELY blank/empty cells in column C.
It will not consider a formula returning "" as blank.

 

[oldbrewer]

try cell EZ1 - it must be blank - in the formula =countif(A1:A10,<>"") should count the non blanks

 

[oldbrewer]

2	1
3	1
	1
4	1
5	1
6	1
	1
7	1
8	1
9	1
		8
		=SUMPRODUCT((A1:A10<>"")*(B1:B10))
		do it the old way lol

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[par60056]

Thank you Jon. That was it. I tried <>"" and it didn't like it.

 

[Jonmo1]

Glad to help, thanks for the feedback.