1.jpg
I wan to calculate the average for three cells not in Sequence using AVERAGEIF with condition (VALUE >0)
1.jpg
I wan to calculate the average for three cells not in Sequence using AVERAGEIF with condition (VALUE >0)
Last edited by a7mad3wies; 12-04-2013 at 04:36 AM.
Hi,
RegardsPlease Login or Register to view this content.
------------------
Edit:
Last edited by canapone; 12-04-2013 at 04:24 AM.
-----------------------------------------------------
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.
Hi again
another possibility
Please Login or Register to view this content.
Regards
Last edited by canapone; 12-04-2013 at 04:25 AM.
please review the excel file attached to get my point clearly
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Hi again
now your title is OK
it should do the trick: in you example 6.5 (5+8)/2Please Login or Register to view this content.
Maybe
could be of some help.Please Login or Register to view this content.
Hope it helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks