SUMIFS less numbers < 0

[cableghost]

In the attached WB, I would like to subtract out the negative points for each of G17, G18, G19. Reason to do this... I want to calculate something in trading called Mark-to-Market. In this manner, I need to substract out the negative points accumulated for each of the formulas. This WB does not have complete data, but enough to make the formulas work.

For example, I bolded the bit of added code below I need to work into the formula for RESULTS 1 G17...

Please Login or Register  to view this content.

[samba_ravi]

Will you show your expected results manually and explain how you got the result

[josephteh]

For G17:=((SUMIFS(Table1[POINTS G/L],Table1[POINTS G/L],">0",Table1[ENTRY],"<"&E17)*F17)/C26)*(C4*C6)

[cableghost]

I get it, super simple... Simply don't count the negative results. Thanks!