I have values in a table like this
Date Values 01/01 5:35 02/01 -7:08 02/01 3:45 15/01 -4:05 02/02 3:25 13/02 4:25 19/02 6:20
I would like to count by month how many 'Values' are negative (i.e. contain a '-' character). I have tried a few things without success. Assume that the values in 'Date' column are real dates so I can use functions like month(). The values in 'Values' column are text (i.e. prefaced with ') as I can't get Excel to cope with negative times correctly.
I was hoping this How can I sum values within a specific time and date range? would help, but I couldn't adapt it for my circumstance.
Appreciate some advice.