Average on conditional formatted cells

[nadavmaroko]

Hi all
I need some help
I've made some rules with conditional formatting on a spreadsheet
Like when true - mark as bold or mark with a blue background.
Now I would like to do some calculations based on those rules.
For example, I need to calculate the average of all bolded cells (and only the bolded cells)
Can it be done and how?

 

[gaz_chops]

Try using the same conditions as your conditional formatting in an averageif(s) formula.

 

[nadavmaroko]

Thanks
But can you show me an example?
If this is my rule:=AND($B5>65,$O5<100)
But it applied on: =$B$5:$AS$2021

I've never used averageif and not sure how to use it

Thanks

 

[gaz_chops]

Try this array formula

=AVERAGE(IF($B$5:$B$2021>65,IF($O$5:$O$2021<100,$B$5:$AS$2021)))

enter using Ctrl, shift & enter