Problem With Average formula

Hello community,

I need help with Excel Average formula, somethink like this:
A B C D E F
Books: 7 14 18 13 17
Phones:9 17 13 23 16
Foods: 6 13 25 17 19

Books: 7 14 18 13 17
Phones:9 17 13 23 16
Foods: 6 13 25 17 19

Books: 7 14 18 13 17
Phones: 9 17 13 23 16
Foods: 6 13 25 17 19

Average for books on B , C ,D ,E ,F
Average for phones on B , C ,D ,E ,F
Average for foods on B , C ,D ,E ,F

Can anyone help me please?

can you define it a little more? is your expectation that (based on your info above) books would average out to 7 in col B? or that it would look across the range of all three rows that contain books and give a total average (13.8)?

I'm still not clear since your post 3 numbers don't match post 1 but I'll give it a go, try average if
so if col A contains Books, Phones and Foods and you want the average for books from col B, then try =AVERAGEIF(A:A,"books:",B:B)

You're welcome, glad I was able to help you. If that solves your issue please mark the post as solved using the thread tools drop down at the top of this post.
And thank you for the rep!

I'm not sure why you are getting a #DIV/0! error. In that formula even if all the values for the books were 0 you'd still get a 0 as the average. But in general for whatever you are using, if you add an IFERROR to the front of the formula and whatever you want to replace it with at the back that CAN take care of it. It will only replace the output of the formula with what you put there, not necessarily a value you want.
so for instance =IFERROR(AVERAGEIF(A:A,"books:",B:B),"what you want to replace the error with here")