ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculation of instances a value is found in a series of cells (https://www.excelbanter.com/excel-worksheet-functions/73668-calculation-instances-value-found-series-cells.html)

DSBTX

Calculation of instances a value is found in a series of cells
 
I have several objects which over several months will change color several
times.
I want to tally at the bottom of my worksheet the total number of instances
of green blue and red for each month. i.e For 10 objects in month one I have
4 green 4 blue and 2 red. The following month I have 5 green, 4 blue and 1
red.

If I code g for green, b for blue and r for red in each cell, how do I
tally these "letters" at the bottom of each month??
Thanks in advance


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com