SUMPRODUCT calcs....

To the brains out there...

In the attached, you can see that I am wanting a formula to show accumulating profits for a certain month AND for a certain ‘type’ of trade. DT would be a ‘day-trade’, for example. This being the case…

I need a formula for N4 that shows the total profits (referencing column H) for the month of June (referencing column I) but ONLY for trades labeled ‘DT’ (as per B column). I'm fairly certain that it's a ‘SUMPRODUCT’ formula that I’ve used before, but I can’t get the syntax. Once one of you provides it, I realize it’s a matter of copying the syntax for all other trade types and as relates to what month they’re occurring in, et al.

Thanks very much and look forward to your solution;

Somebodyhadto.

Martin B.