Problem with Frequency() formula

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

Why/how would such a thing occur?

Age today Bins Count Formula under Count:
65 70 1
<<{Frequency($DATA$RANGE,$BIN$RANGE)}
69 65 4 ""
63 60 0 ""
71 1 ""
65
62

Formula is obviously wrong (DATARANGE is formula Datedif(x,y,"y").
TIA,
 
The result gives you "less than or equal to" from the bin. So its correct.
Try putting the bin in ascending order, and you will get correct expected
answers.

Mangesh
 
Thanks Mangesh,

Mangesh Yadav said:
The result gives you "less than or equal to" from the bin. So its correct.
Try putting the bin in ascending order, and you will get correct expected
answers.

Mangesh
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count and Sum Total occurrances of two specific numbers 10
Match Last Occurrence of two numbers and Return Date 6
Match Last Occurrence of two numbers and Count to Previous Occurence 31
Frequency Formula 5
Excel formula calculating age 4
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
Formula to group into Age Ranges 2
How Do I Query a Named Range 2

Back
Top