Frequency Calculation

[KristieLee1]

I know this is the wrong forum, but I was hoping to catch Ties. I have a feeling you'll know this as you are super smart.

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 in 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 from the pivot, 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!

 

[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!