Hi
Looking for some help.
I have a worksheet which has various figures for each Year however I need to average these figures which are not in a range which ignores any zero values
I have attached a test sheet as an example.
Thanks
Ahmed
Hi
Looking for some help.
I have a worksheet which has various figures for each Year however I need to average these figures which are not in a range which ignores any zero values
I have attached a test sheet as an example.
Thanks
Ahmed
Hi,
some possible formula
=(B3+D3+F3+H3)/((B3<>0)+(D3<>0)+(F3<>0)+(H3<>0))
=SUM(INDEX(B3:I3*(MOD(COLUMN(B3:I3),2)=0),))/SUM(INDEX((B3:I3<>0)*(MOD(COLUMN(B3:I3),2)=0),))
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Try this...
=SUMPRODUCT(1*ISEVEN(COLUMN(B3:H3)),B3:H3)/SUMPRODUCT(ISEVEN(COLUMN(B3:H3))*(B3:H3>0))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks