Please Register to Remove these Ads
I've setup a workbook that contains a lot calculations. One of the columns in my workbook is setup to check certain cells and based on conditions I've setup, the cells will be filled in with the word "red" or "green."
I need to learn how to create a function that will add up the number of cells that have the word "red" in them and divide that by the total number of cells ("red" or "green").
So essentially I'm finding an average: red cells over both red and green cells.
Is this possible?
Linear Mode
