Frequency Calculation

[KristieLee1]

Sorry if this is the wrong forum to post this in.

I have a frequency table that is consistently omitting 1 from my counts. I have x number of y, and when I sum x its one short at least one of my bins. My formula works perfectly if I do the frequency on all records, if I start filtering the records, it omits one in a seemingly random fashion. I know it isn't random, it just appears that way to me.

Here is my formula, my data is in a pivot table, the frequency calc resides outside the pivot.

=FREQUENCY($B:$B,F23:F33) col. b is my data col f is my upper range listed in the to column below.


week to freq
0 3.99 17
4 7.99 7
8 11.99 6
12 15.99 10
16 19.99 19
20 23.99 36
24 27.99 29
28 31.99 26
32 34.99 10
35 38.99 6
39 42.99 0
Total 166
Any help would is appreciated. Thank you!

 

[SkipVought]

Hi,

You have not clearly explained how your ranges in your formula, relate to your example.

What data IN YOUR EXAMPLE is in column B?

What data IN YOUR EXAMPLE is in F23:F33?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[KristieLee1]

I figured it out!!! I was including the entire column b, which happened to contain the filters I was using in my pivot. So, my frequency was actually adding the filtered number to the frequency count, if that makes sense. I simply adjusted my column b to exclude the cell I was using the filter on, and it worked!

YAY!

Skip, sorry for the vague description.

My data in col b is the count of ages. The data in F is the frequency calculation

I was trying to get the frequency of weeks each child attended class.

So, example...4 kids attended class for 0-3.99 weeks, 15 kids attended for 4-7.99 weeks, etc.

I had included my pivot table filter (which is in column B, where my count of ages is) in the frequency formula. I have excluded that cell and now the formula works.

Sorry again.