Hi, There is usually more than one way of accomplishing a task in Microsoft Office. You don't need to use Excel's formula bar to enter formulas. What kind of requirement is this?
To input a Frequency function, try the following. 1. Select the range where you need to insert the frequency distribution making sure that you select one cell more than your data. Select 11 cells if you are working with 10 cells of data. 2. Press F2 and type the formula with range references or range names whichever you are using. =FREQUENCY(S2:S11,T2:T11), or =FREQUENCY(Students,Marks) 3. Press Ctrl + Shift + Enter to enter the formula as an array formula. --- On Thu, 3/3/11, karan yourdestiny <[email protected]> wrote: > From: karan yourdestiny <[email protected]> > Subject: [AI] accessing formula bar in excel 2007 > To: [email protected] > Date: Thursday, March 3, 2011, 1:00 PM > hi members > i have to enter frequency formula in excel 2007 and it has > to be > written in formula bar. in excel 2003, i can access it by > using route > jaws to pc cursor and then by pressing left mouse button. > but when i > follow the same procedure in excel 2007, nothing fruitful > happens. > what shall i do? please help me. > thanks and regards > karan > mob:78 38 76 12 23 > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any > other changes, please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
