Sumif or if formula

[Nightcrawller]

Dear all.

I would like to use the SUMIF function in the following way:
-Sum range is 2:2
-Criteria Range is 1:1
-Criteria is number >1




Foreg: in this screenshot i just want to sum total sets of each game and to determine each game i have to take one factor but not the range.

So what i want is =sumif(A15, ">=2",D15:D16) but it dosent work because a15 is not a range. In simple terms what i want is ifba cell contains a number then add that cell with the cell below.


Thanks

 

[Aladin Akyurek]

An image or a picture are not helpful.

For:

" would like to use the SUMIF function in the following way:
-Sum range is 2:2
-Criteria Range is 1:1
-Criteria is number >1"


=SUMIFS(2:2,1:1,">1")



Hard to follow:

"Foreg: in this screenshot i just want to sum total sets of each game and to determine each game i have to take one factor but not the range.

So what i want is =sumif(A15, ">=2",D15:D16) but it dosent work because a15 is not a range. In simple terms what i want is ifba cell contains a number then add that cell with the cell below."

Looks like:

=IF(A15>=2,SUM(D15:D16),0)

Hope this helps.

 

[Nightcrawller]

Works like magic, didn't realize that we can put a formula instead of 1,0 in if formula.

Thanks

 

[Aladin Akyurek]

Works like magic, didn't realize that we can put a formula instead of 1,0 in if formula.

Thanks

You are welcome.