SUMIF Not blank

[RJB78]

Hello. I have a set of account program titles(B) and a dollar value(J) and for some accounts there is not a program title and the cell is blank or empty (not sure what definition fits this situation, there is no formula in the cell). I would like to sum all of the dollar values for which there is a program title. I tried using =SUMIF(B34:B5000,"<>"&"",J34:J5000) but it returned the total dollar value for all accounts (even without a program title).

What can I use to sum the dollar values beginning in if that account is in a program?

Thank you in advance

 

[Joe4]

It sounds like those cells are not really empty, but have something in them (like a space or special character).
Find one of these apparent "blank" cells. Let's say it is B50. Then see what this formula returns:
=LEN(B50)

If it returns anything other than 0, then your "blank" cells are not really blank, and that is why your formula is not working the way you want.

 

[RJB78]

Thank you Joe - Len(B50) (B50 happens to be blank cell) = 0

 

[Joe4]

That does not make sense to me. Then your SUMIF formula should work.
I tested out the EXACT equation you posted, and it ignore all rows with blanks in column B in the SUM.

 

[Scott T]

Playing around with this I found that with the posted formula if I put ="" in a cell in column B it still counts the row.
However this formula no longer counts that row

=SUMPRODUCT(--(B34:B5000<>""),J34:J5000)

not sure why the same condition would produce different results

 

[XOR LX]

If the Program Titles are text entries, not numeric:

=SUMIF(B34:B5000,"?*",J34:J5000)

Regards

 

[RJB78]

Thank you all, the program titles are text entries, so XOR LX advice worked perfectly. I apologize for not saying that in my original post.

Thank you.

 

[XOR LX]

You're welcome!

Cheers