jimbo

Posts: n/a

Using Frequency formula

hi,
im trying to figure out the frequency of a sample of students final marks
and this is the formula im using '=FREQUENCY(FinalMarks,B11:B12)' but as i go
from B11:B12 to B12:B13 it accumulates the score instead of just counting the
frequency of B12:B13. how do i adjust the formula so it doesn't accumulate
thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referencing named formula using INDIRECT function	[email protected]	Excel Worksheet Functions	19	May 11th 05 09:48 AM
Simplify formula	Luke	Excel Worksheet Functions	37	May 6th 05 07:21 AM
Frequency for Histograms in Excel	Jim	Charts and Charting in Excel	7	February 24th 05 07:33 PM
Formula or not?	Alan	Excel Worksheet Functions	2	February 20th 05 03:26 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM

All times are GMT +1. The time now is 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us