Hello,
I'm trying to figure a average formula but I'm having no sucess ....
On the attached example ...in cell DD9 you see the following formula ....
this is the only formula that works for me ....
Please Login or Register to view this content.
I have tried the following with no luck
Any help/suggestions are appreciatedPlease Login or Register to view this content.
Arvin
Last edited by NBVC; 06-24-2010 at 09:46 AM.
=AVERAGE(IF(D7:DC7 ="Actual", D9:DC9)), confirmed with Ctrl+Shift+Enter
Entia non sunt multiplicanda sine necessitate
Wow!
Thank you so much ... I tested it and It works!
Thank you, Thank you, Thank you, Thank you
Hello,
Okay so ... I tried the same formula in cells DD10 to DD14 and it works but the results are strange ... In thsoe cells, I'm looking for the Average Hours worked
this is the formula I'm using
Please Login or Register to view this content.
Not really ...Originally Posted by arvin
The first average array in row 9 "works" because you're using "0%" as the default value in the source columns. "0%" is not a number - thus these values do not affect the final average.
In row 10 the 0's are real numbers and are included in the Average thereby lowering final result. If you want to omit 0's also then use:
=AVERAGE(IF((D7:DC7= "Actual")*(D10:DC10),D10:DC10))
confirmed with CTRL + SHIFT + ENTER
this would generate 24.38 per your data
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
My sincere apologizes for the delay in my response ... we had a baby so I was a bit busy
I just wanted to say that I tried what DonkeyOte had suggested and it worked perfectly ...
Thank you all for your assistance ...I appreciate it ...take care
Congratulations, Arvin.
we had a baby so I was a bit busy
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you very much....
Just one thing ...for some reason ...i cannot mark this thread "solved" ...I'm following the instructions in the FAQ section .... but its doesn't allow me to edit the "1st" post .... only the last post ...
It is because the thread is more than 2 days old... I have marked it for you.
Awesome!!!
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks