How do i count if the cell is greater than my avg?

ECD Auto Design

I am trying to countthe number of cells if the cell value is greater than my avg.This is the formula i try but i cant seem to figure it out" =COUNTIFS([Actual Build Length (Months) (Elliot)] > [Actual Build Length (Months) (Elliot)]1)"

Any Suggestions?

Bassam Khalil

Hi @ECD Auto Design

Hope you are fine, please try the following formula:

=COUNTIFS([Actual Build Length (Months) (Elliot)]:[Actual Build Length (Months) (Elliot)], @cell > [Actual Build Length (Months) (Elliot)]1)

Bassam Khalil

Hi @ECD Auto Design

Hope you are fine, please try the following formula:

=COUNTIFS([Actual Build Length (Months) (Elliot)]:[Actual Build Length (Months) (Elliot)], @cell > [Actual Build Length (Months) (Elliot)]1)

Bassam Khalil

@ECD Auto Design

You are welcome and I will be happy to help you any time.

ECD Auto Design

@Bassam Khalil

Thank you for your previous help, I have made some changes to my sheet and i cant seem to fix my formula like i had it before. Do you think you can review this and help me figure out where i went wrong? Just as a refersher to what i am trying to accomplish, I would like to count the total number of cells that are above my average on line 2. Thank you for your time!

=COUNTIFS([Projected Build Time (Months) (Elliot)]5:[Projected Build Time (Months) (Elliot)]90 > [Projected Build Time (Months) (Elliot)]2)