I have another averageif scenario
the formula I have is as follows;
=AVERAGE(IF(((Properties!S3:S1002="Y")+(Properties!S3:S1002="A")),Properties!BY3:BY1002))
Column S may have blank cells but the corresponding cell (same row) in column BY may be populated. I can't get it to not take into account any cell in column BY that is populated but blank in column S.
Any help would be much appreciated! (PS will read carefully and follow instruction properly this time).
Bookmarks