I'm looking to get the difference (profit) between BUY and SELL for each day (column A). I've managed to get overall difference between BUY and SELL for all days but would like have each day calculated in totals per day in B:9 to B11.
So far I have this formula below but it just calculates total difference on all days between BUY and SELL In Column B.
=SUMIF(C:C,"SELL",H:H)-(SUMIF(C:C,"BUY",H:H))
How can I alter this function to reference the totals only for the specific date in column A?