Hello All
On the attached worksheet I have groups of data in cols A,D,E,in col H i have positive & negative values for each group.I would like to count the total number of positive & negative values for each group,the results being given in col K.Negative totals are preceded by a minus sign & placed alongside the negative values in col H.eg first group has a total of 2 negative values so total is shown as -2 alongside negative values in col H,same for positive values as shown.Blanks & zeros in col H are ignored.I have inserted an empty row between groups for clarity,there are no empty rows in the data.Many thanks for help given.
Bookmarks