Check for values in a table and if found add value found in column to left to list

Hello Rob
I apologise, it's not just a case of reversing the formulas as I thought, didn't think it through. The only way I can think of at the moment to bring back the negatives for each day is to use a separate count table. In the attached reply I've done that and created a few Named ranges for ease of reference. You could use Fotis's Array formulas with this table if you wish, it's a matter of preference if you're happy to use them.

Perahps Fotis or another forum member might have a solution for returning the negative days without a helper table.

Regards
DBY