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:

Date<strike></strike>	<strike></strike>Profit	Rating
1/10	-7	1.9
1/10	10	1.6
2/10	10	1.7
2/10	10	1.86
3/10	-7	1.9
3/10	10	1.5
3/10	10	1.2

<tbody>
</tbody>

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