I have the following formula courtesy of Daddylonglegs but I need to add another 2 variables to it.
=SUM(SUMIF(Properties!$S$3:$S$1002,{"Y","A"},Properties!$CH$3:$CH$1002))/MAX(1,SUM(COUNTIFS(Properties!$S$3:$S$1002,{"Y","A"},Properties!$CH$3:$CH$1002,"<>")))
I need the formula to check if column s = Y or A and column v = Y or A then, sum column CH
This also needs to be applied to the countifs statement.
I have tried the following but I just get and error message, getting really stuck now.
=SUM(SUMIF((Properties!$S$3:$S$1002,{"Y","A"}*Properties!$v$3:$v$1002,{"Y","A"}),Properties!$CH$3:$CH$1002))/MAX(1,SUM(COUNTIFS(Properties!$S$3:$S$1002,{"Y","A"}*Properties!$v$3:$v$1002,{"Y","A"}),Properties!$CH$3:$CH$1002,"<>")))
Bookmarks