UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Averaging data based on a seperate column...    
 
   
brycole
post Mar 28 2005, 07:57 PM
Post #1

UtterAccess Veteran
Posts: 460
I've been toying with this all day, cant seem to get it to work


=IF((AND( I5:I9 = "b")), AVERAGE(K5:K9), "")

I want it to check All the I's for "B" and then after its done take another columns DATA and AVERAGE it based on the "B" Rows...


But its not working...ug, will I have to use an array or something? Theres gotta be something I'm missing.


-Bryan
Go to the top of the page
 
+
WillR
post Mar 29 2005, 06:51 AM
Post #2

UtterAccess Enthusiast
Posts: 99
From: Rugby - UK
YES

=AVERAGE(IF(I1:I10="B",K1:K10))

Array entered using CTRL+SHIFT+ENTER
Go to the top of the page
 
+
brycole
post Mar 29 2005, 11:56 AM
Post #3

UtterAccess Veteran
Posts: 460
Ok...I must be missing something, I put the formula in for the array and...it just stays there, how do i get it to print the value out in a cell?
Go to the top of the page
 
+
brycole
post Mar 29 2005, 12:05 PM
Post #4

UtterAccess Veteran
Posts: 460
Lol! I'm not sure what happened but it works now! It perfectly, thanks a ton!!!(IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)





-Bryan
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 10:38 AM