Excel syntax question.
By
Ironblade,
Posted on: 2010-05-12 07:19 in ALL ACCESS Gameplay Technical Issues Bugs
Well, first off, is there a reason why you can't make Ei = Di/($B$4 * Ci), and then take the average of column E?
Failing that, your formula can be rewritten like this:
=SUMPRODUCT(D7;D10,1/(B4*(C7:C10)))/COUNT(D7;D10)
(Just replace the semicolons with colons..accursed formula smilies)
Quote:
Ah! I figured out the Sumproduct part on my own, but not the COUNT function. I was trying to find that. Thanks.
|
Originally Posted by Korith
Well, first off, is there a reason why you can't make Ei = Di/($B$4 * Ci), and then take the average of column E?
Failing that, your formula can be rewritten like this: =SUMPRODUCT(D7;D10,1/(B4*(C7:C10)))/COUNT(D7;D10) (Just replace the semicolons with colons..accursed formula smilies) |
Quote:
Suggestion (in case anyone needs to do this again): If you have to post formulas or code of any kind, just wrap them in the code tag (left square bracket, the word code, right square bracket, the code or formula you need to post, then left square bracket, forward slash, the word code and right square bracket ... or choose the number symbol from the menu just above the message box), like this:|
Originally Posted by The_Coming_Storm
Oh. Question on an excel sheet. I thought I had everything ready but I seem to not know syntax
=AVERAGE(SUM((D7  10)/(B4*(C7:C10))))I want to take the average of the sums of Di/(B4 * Ci) . |
Code:
=AVERAGE(SUM((D7:D10)/(B4*(C7:C10))))
Storm
Serenity is not freedom from the storm, but peace amid the storm ...
Quote:
Another option is to check Disable Smilies In Text. Under the area where you type your reply is the section for Post Icons, and then the Submit and Preview buttons. Below those are Additional Options.|
Originally Posted by PerfectStorm
Suggestion (in case anyone needs to do this again): If you have to post formulas or code of any kind, just wrap them in the code tag (left square bracket, the word code, right square bracket, the code or formula you need to post, then left square bracket, forward slash, the word code and right square bracket ... or choose the number symbol from the menu just above the message box), like this:
Code:
=AVERAGE(SUM((D7:D10)/(B4*(C7:C10)))) Storm |
The first Additional Options options are labeled Miscellaneous Options, and include: Show you signature, Automatically parse links in text, and Disable smilies in text.
=SUMPRODUCT(D7:D10,1/(B4*(C7:C10)))/COUNT(D7:D10)
Also, [noparse][/noparse] tags should work, too:
=SUMPRODUCT(D7:D10,1/(B4*(C7:C10)))/COUNT(D7:D10)
Who says options are a bad thing? :)
[ ProTip: The banner is a link to art refs!! | The Khellection | The HBAS Repository | Brute Guides (4/16/10) | How To Post An Image - A Quick Guide ]
Biggest Troll on the forums? I'll give you a hint:
Quote:
Well, I would say your biggest problem is that smilie in there. |
Originally Posted by The_Coming_Storm
Oh. Question on an excel sheet. I thought I had everything ready but I seem to not know syntax
=AVERAGE(SUM((D7 10)/(B4*(C7:C10)))) |
Sorry, couldn't resist.
Paragon City Search And Rescue
The Mentor Project
Oh. Question on an excel sheet. I thought I had everything ready but I seem to not know syntax
10)/(B4*(C7:C10))))
=AVERAGE(SUM((D7
I want to take the average of the sums of Di/(B4 * Ci) .