Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
101
Views
Topic starter
Hi
I can not work out why the formula is giving an error?
Any help greatly appreciated
Regards
Paul
Posted : 01/05/2020 1:28 pm
I think that Averageif needs a range rather than selected cells
=AVERAGEIF(B4:H4,">0") seems to work okay, doesn't work with named range either as far as i can see
Purfleet
Posted : 01/05/2020 2:37 pm
Hi Paul,
You need to unpivot the data so it's in a tabular format to work with these functions. They are not designed to work with non-continuous columns.
Mynda
Posted : 01/05/2020 9:10 pm
Topic starter
Thank you for the update
Regards
Paul
Posted : 02/05/2020 5:24 am
