Hello all
I would like help in summing up totals in multiple columns based of the colour of the columns, please see attached spreadsheet.
Total the value in grey, brown and yellow columns but limited to the yellow column, the great value in ether grey column and the greater 2 values in the brown with the total showing in column E.
Also the number of events that the above totals points to show in column F as shown in E5 & F5 (manually entered)
Thank you in advance.
Bookmarks