To average cells included texts - how to ignore texts in those cells - help please

[PrayoonD]

Hi guys - would anyone please help on this? I have attached a question that I am working on.

Thank you very much.

[FDibbins]

Hi, welcome to the forum

TRy this...
=SUMPRODUCT(--(LEFT(B3:B7,1))/COUNTA(B3:B7))

[ELeGault]

FDibbins,

I did not think of that, simply brilliant - and a Palm in hand moment...

I was going here...
=SUM(COUNTIFS($B$3:$B$9,"*1*"),COUNTIFS($B$3:$B$9,"*2*")*2,COUNTIFS($B$3:$B$9,"*3*")*3,COUNTIFS($B$3:$B$9,"*4*")*4,COUNTIFS($B$3:$B$9,"*5*")*5)/SUM(COUNTIFS($B$3:$B$9,"*1*"),COUNTIFS($B$3:$B$9,"*2*"),COUNTIFS($B$3:$B$9,"*3*"),COUNTIFS($B$3:$B$9,"*4*"),COUNTIFS($B$3:$B$9,"*5*"))

[PrayoonD]

Cool. Thank you very much @FDibbins

[FDibbins]

Happy to help, and thanks for the kind words. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[PrayoonD]

Marked SOLVED as suggested. Thanks FDibbins.