Hello everyone,
I wanted to know if there is a formula, or if anyone has any better suggestions on how to solve my current problem with finding the average of a range of cells, based on the color of the cell and if they value is either "Yes", "No", or "0".
I know that I could also use the filter by function, but I would like to see if anyone knows a formula that could possibly calculate it without me having to use filter by COLOR.
For example, when a cell that is filled with YELLOW, and has a YES, No, or 0... I can find the average of only those. Currently I have the following formula to find the average of all : =AVERAGE(IF(I3:I33="Y",1,IF(I3:I33="NO",0,"")))
Any suggestions or if you all can think how I could go about doing this in a better way?
Here is a snip of what I am talking about.
Excel.png
Bookmarks