SUMIF with IF

[Candles]

Hi,

I am trying to total the sum of all items per day but only if another column is over a certain amount. My table looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date<strike></strike>
[/TD]
[TD]<strike></strike>Profit
[/TD]
[TD]Rating
[/TD]
[/TR]
[TR]
[TD]1/10
[/TD]
[TD]-7
[/TD]
[TD]1.9
[/TD]
[/TR]
[TR]
[TD]1/10
[/TD]
[TD]10
[/TD]
[TD]1.6
[/TD]
[/TR]
[TR]
[TD]2/10
[/TD]
[TD]10
[/TD]
[TD]1.7
[/TD]
[/TR]
[TR]
[TD]2/10
[/TD]
[TD]10
[/TD]
[TD]1.86
[/TD]
[/TR]
[TR]
[TD]3/10
[/TD]
[TD]-7
[/TD]
[TD]1.9
[/TD]
[/TR]
[TR]
[TD]3/10
[/TD]
[TD]10
[/TD]
[TD]1.5
[/TD]
[/TR]
[TR]
[TD]3/10
[/TD]
[TD]10
[/TD]
[TD]1.2
[/TD]
[/TR]
</tbody>[/TABLE]

I want to add all the profit up for each day, if the rating is over 1.85.

Thanks

 

[mrshl9898]

In D2

=IF(C2>1.85,SUMIF(A:A,A2,B:B),"")

 

[barry houdini]

Don't you want that to be another condition in the SUMIF? If so try SUMIFS:

=SUMIFS(B:B,A:A,A2,C:C,">1.85")

 

[FDibbins]

In D2

=IF(C2>1.85,SUMIF(A:A,A2,B:B),"")

That will only test for C2. If C2 meets the test, then all values in B will be summed...if C2 does not pass, nothing will be summed

 

[mrshl9898]

Correct. Also shows 2/10 profit as 20 instead of 10.

 

[FDibbins]

OP wanted to only include values to sum where the corresponding value in (all of column) C was > 1.85, not just that single cell