Sum if not blank

[RincewindWIZZ]

So I have the following data:
A1:A10 all contain 1 (for simplicity)
B1 to B10 contains formula that evaluate either to a number or to ""
Lets say 8 evaluate to a number (some of which are 0) and 2 evaluate to ""


I want to sum all the cells in A for which the corresponding cell in B is not "" so I tried
SUMIF(A1:A10,criterion,B1:B10)

Criterion Result
"". . . . . . . . gives . . . 2
"<>" . . . . . .gives. . . 10
"<>"&"". . . .gives. . . 10
">""". . . . . .gives. . . .0
">=""". . . . gives. . . .0
">"&"". . . . gives. . . . 0
"<>"&C1. . .gives. . . 10 (c1 contains ="")
So what criterion should I use?

(OK there are other ways I can do this but it seems odd to me that I cannot find an appropriate criterion for SUMIF)

 

[Joe4]

What exactly what is the formula you are using in column B?

 

[Fluff]

I also think that you have the ranges the wrong way round. The first range is the criteria range & the second is the range to sum.

 

[Aladin Akyurek]

=COUNTIFS(A1:A10,1,B1:B10,"<>")

looks more likely. Otherwise post a sample along with conditions and the result that must obtain.

 

[RincewindWIZZ]

Hhhmmm a problem as it says I cannot post attachments!
How do I post a sample spreasheet?

 

[Joe4]

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Otherwise, you would have to upload a file to a public file sharing site and post the link here.
Note though, many people are unable or unwilling to download files off of the internet for security reasons.

 

[Aladin Akyurek]

Hhhmmm a problem as it says I cannot post attachments!
How do I post a sample spreasheet?

Did you run the proposed formula?

 

[RincewindWIZZ]

OK so it seems I have to do it this way

So the question is what criterion do I put into the SUMIF formula in D4 to give the answer 6 which is the sum of the entries in Col B for which Col C is not blank

 

[RincewindWIZZ]

And hopefully the spreadsheet can be found here
https://1fichier.com/?s7ge13euusesevej67z7

 

[Fluff]

Excel 2013/2016
	B	C	D
4	1	1	6
5	2
6	1
7	2	0
8	1	0
9	2	1
Dont Delete

Cell Formulas
Range	Formula
D4	=SUMIF(C4:C9,"<>",B4:B9)