Sales- Calculate Minus or Plus at days

[makispatos]

Hello all,

I am trying to make the sample book I attach to work like that.
I can calculate the Sales Clearance and Clearance Fee but in total per day.
I need to make it again per day but now calculate minus and plus per day.
If you see at day 08/04 Sales clearance for the same day has and minus or plus

8/4/2022 Sales Clearance 3.769,00
8/4/2022 Clearance Fee -77,08
8/4/2022 Sales Clearance 2.824,00
8/4/2022 Clearance Fee -59,37
8/4/2022 Sales Clearance -6.840,00
8/4/2022 Clearance Fee 152,05
8/4/2022 Sales Clearance -5.250,00
8/4/2022 Clearance Fee 113,02
8/4/2022 Sales Clearance 360,00
8/4/2022 Clearance Fee -7,30
8/4/2022 Sales Clearance 204,00
8/4/2022 Clearance Fee -4,08
8/4/2022 Sales Clearance 280,00

I want to calculate and minus and plus at different rows in order to know what happened that day.

Please help

Thanks!

[popipipo]

Please Login or Register  to view this content.

Maybe this will work

[makispatos]

Thank you for your reply
I figure it out with help from yours solution and it is

=SUMIFS($C$2:$C$435;$B$2:$B$435;"=Sales Clearance*";$C$2:$C$435; ">0";$A$2:$A$435;A437)
=SUMIFS($C$2:$C$435;$B$2:$B$435;"=Sales Clearance*";$C$2:$C$435; "<0";$A$2:$A$435;A437)

Thanks again!