I don't even know if this is possible but I thought I would ask you folks. I have attached a screenshot so the following problem makes sense:
The Cell I am trying to write a formula for is cell C28. I am trying to figure out a formula that will only count Cells C11, C12, C14, C15, & C20 with a variable of "1" if those Cells are equal to or greater than the cells imediately to their left (D11, D12, D14, D15, & D20). Specifically, Cell C11 will only be counted with a varible of "1" if it is greater than or equal to cell D11. If it is less than the value of Cell D11, it will not be counted. Therefore, cell C28 will show a maximum value of "5" if all of the C cells above it are equal to or greater than the D cells. However, if one of the cells is less than the D values, cell C28 will read "4".
I have spent the greater part of the day searching for this but am at a complete loss on where to even begin. Any ideas?
Please see attachement. Thanks
Bookmarks