Database
[{"_id":ObjectId("5ee1e209e07f053f990cea8c"),"key":"TAKwGc6Jr4i8Z487","createdAt":ISODate("2017-01-28T01:22:14.398Z"),"counts":[150,160],"value":"Doc1"},{"_id":ObjectId("5ee1e8dee07f053f990ceaa1"),"key":"TAKwGc6Jr4i8Z487","createdAt":ISODate("2017-01-28T01:22:14.398Z"),"counts":[170],"value":"Doc2"}]
Query
db.collection.aggregate([{"$match":{createdAt:{$gte:ISODate("2017-01-28"),$lt:ISODate("2017-01-29")}}},{$addFields:{sum:{$sum:"$counts"}}},{"$match":{sum:310}},{$unset:"sum"}])