Count If/Or and Exclude blank cells

Okay - what I'm looking for is a formula to count the total values in column C starting at row 6 for all values with a building status of "UC".

This is what I came up with:

=SUM(IF(ISNUMBER(MATCH($A$6:$A$26,{"UC","UR"},0)),$C$6:$C$26))/COUNT(IF(ISNUMBER(MATCH($A$6:$A$26,{"UC","UR"},0)),$C$6:$C$26<>"",C6:C26)>0,Table1[Average asking rent p.s.f. (FSG)])

The last part of the formula is calculating the total number of values in column C correctly (13) but it's not accurately looking at column A for UC building status.. instead it's calculating all.

Ultimately, it should average column C as long as it's a UC OR UR building.

Thanks so much and look forward to see what you come up with!

Count If Or Exclude Blank.xlsx

Try

=AVERAGE(IF(Table1[Building status]={"UC","UR"},IF(Table1[Average asking rent p.s.f. (FSG)]>0,Table1[Average asking rent p.s.f. (FSG)],""),""))

Enter with Ctrl+Shift+Enter

Perfect - thank you so much!

Thanks you for the feedback and rep.

If your problem has been addressed, can you mark thread as solved ("Thread Tools" at top of first post)