Hi,
I would like to calculate average of a column, based on condition.
let's take an example (see screenshot)
example US.png
if SUM(adults + Children) >=5, i want to calculate average price of Hotel room.
so in my example to calculate average of (2000 and 5321).
How can i do that ?
thx,
I cannot see your picture. Please post a sample workbook with sample results mocked up manually. Thanks.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Sorry guyz, but different forums so multiple chance to get answer.
by the way, if there is more forums it's because people do not get answers for there questions on the same place...as nobody is registered everywhere...
Sorry JBeaucaire, but i can perfectly see thescreenshot so i do not know where is the problem with you
=sumproduct(--(b2:b100+c2:c100>=5),a2:a100)/sumproduct(--(b2:b100+c2:c100>=5))
Cross post without links http://www.msofficeforums.com/excel/...2-columns.html
Actually, let me clear that up for you... same question on multiple forums means you will almost guaranteed to waste somebody's time on one of these forums. Obviously that's great for you and a total slap in the face to us, the helpers.Originally Posted by rafnews
This thread will be closed. Before you post again on our forum to get free assistance from our awesome helpers, please read the Forum Rules, the same ones we all abide for the good of all, as must you.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks