Database

[{Iva:0.19,state:"Successfull",clientID:"N/A",payment:"Cash",seller:"60eadfafkla5we321d",consecutive:35612,secId:6,subtotal:8500,combined:true,pay_cash:0,pay_card:4000},{Iva:0.19,state:"Successfull",clientID:"N/A",payment:"Cash",seller:"60eadfafkla5we321d",consecutive:35612,secId:6,subtotal:8500,combined:true,pay_cash:4500,pay_card:4000},{Iva:0.19,state:"Successfull",clientID:"N/A",payment:"Combined",seller:"60eadfafkla5we321d",consecutive:35612,secId:6,subtotal:8500,combined:true,pay_cash:0,pay_card:4000},{Iva:0.19,state:"Successfull",clientID:"N/A",payment:"Card",seller:"60eadfafkla5we321d",consecutive:35612,secId:6,subtotal:8000,combined:true,pay_cash:1,pay_card:4000},{Iva:0.19,state:"Successfull",clientID:"N/A",payment:"Pepe",seller:"60eadfafkla5we321d",consecutive:35612,secId:6,subtotal:8500,combined:true,pay_cash:0,pay_card:4000}]

Query

db.collection.aggregate([{$group:{_id:null,totlaCash:{$sum:{$cond:[{$or:[{$in:["$payment",["Cash","Card","Combined"]]},{$gt:["$pay_cash",0]}]},"$subtotal",0]}}}}])

Result