Hi
I am trying to interrogate a spreadsheet to look down two columns comparing only Cells that have P5 in the C column and if column Y is greater than column L - as can be seen below)
SUMPRODUCT(--(SCHOOL!$C:$C="P5"), --(SCHOOL!Y:YgreaterthanSCHOOL!L:L))
This produces the number of cells that this applies to but I want to factor in a BUFFER.
E.g. If the Cell checked in column Y is 5% above that of Column L then count it.
How do I add this to the formula?
Nb words used instead of symbol in formula, purely due to filters on this website
Bookmarks