I am trying to select those values from a one-dimensional range of data that fall below the average. Also, I am trying to count how many of them there are, and finally, to calculate the variance.
This code doesn't seem to be working and I think the problem comes when I populate the array :/
Please Login or Register to view this content.
I am working with the file in the attachment.
Last edited by seigna; 05-04-2013 at 04:33 PM.
An array formula could do the same.
=VAR(IF(A2:A15<AVERAGE(A2:A15),A2:A15,""))
Confirm the formula with Ctrl+Shift+Enter
Otherwise, put the code below in a standard code module; e.g. Module1, and not the Worksheet's code module
Please Login or Register to view this content.
Does the resulting MoyBelow take into account ONLY the values inside the new v(i,1)?
Otherwise, would you be able to tell my what's wrong with my formula? (Or anyone else, ofc)- I'd really like to use it in that form... I know I could use worksheet functions but I'll leave that as a last resort option...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks