Frequency formula

Johnboy28

Board Regular
Joined
Jun 22, 2013
Messages
198
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2010
Platform
  1. Windows
Hi, Can anybody tell me if you can add a date search to a Frequency formula?

Thank you


<tbody>
[TD="class: xl64, align: center"]A[/TD]
[TD="class: xl64, width: 127, align: center"]B[/TD]
[TD="class: xl64, width: 137, align: center"]C[/TD]
[TD="class: xl64, width: 41, align: center"]D[/TD]
[TD="class: xl64, width: 87, align: center"]E[/TD]
[TD="class: xl64, width: 87, align: center"]F[/TD]
[TD="class: xl64, width: 87, align: center"]G[/TD]
[TD="class: xl64, width: 87, align: center"]H[/TD]
[TD="class: xl64, width: 87, align: center"]I[/TD]
[TD="class: xl64, width: 104, align: center"]J[/TD]

[TD="class: xl64, align: center"]2[/TD]
[TD="class: xl71, width: 127, align: center"]WE Date[/TD]
[TD="class: xl70, width: 137, align: center"]Data[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]3[/TD]
[TD="class: xl72, align: center"]Sun 01/10/17[/TD]
[TD="class: xl67, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl66, align: center"]Weight[/TD]
[TD="class: xl63, align: center"]Sun 01/10/17[/TD]
[TD="class: xl63, align: center"]Sun 08/10/17[/TD]
[TD="class: xl63, align: center"]Sun 15/10/17[/TD]
[TD="class: xl63, align: center"]Sun 22/10/17[/TD]
[TD="class: xl63, align: center"]Sun 29/10/17[/TD]

[TD="class: xl64, align: center"]4[/TD]
[TD="class: xl75, align: center"]Sun 01/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl67, align: center"]35[/TD]
[TD="class: xl67, align: center"]0[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"][/TD]

[TD="class: xl64, align: center"]5[/TD]
[TD="class: xl75, align: center"]Sun 01/10/17[/TD]
[TD="class: xl68, align: center"]67[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]39[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]6[/TD]
[TD="class: xl75, align: center"]Sun 01/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]43[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]7[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]47[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]8[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]78[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]51[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]9[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]55[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]10[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]59[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]11[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]68[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]63[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]12[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]67[/TD]
[TD="class: xl68, align: center"]1[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]13[/TD]
[TD="class: xl75, align: center"]Sun 08/10/17[/TD]
[TD="class: xl68, align: center"]74[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]71[/TD]
[TD="class: xl68, align: center"]23[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]14[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]75[/TD]
[TD="class: xl68, align: center"]3[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]15[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]79[/TD]
[TD="class: xl68, align: center"]2[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]16[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"]83[/TD]
[TD="class: xl68, align: center"]0[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]

[TD="class: xl64, align: center"]17[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl69, align: center"]Total[/TD]
[TD="class: xl69, align: center"]4415[/TD]
[TD="class: xl69, align: center"]4416[/TD]
[TD="class: xl69, align: center"]4417[/TD]
[TD="class: xl69, align: center"]4418[/TD]
[TD="class: xl69, align: center"]4418[/TD]

[TD="class: xl64, align: center"]18[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]19[/TD]
[TD="class: xl75, align: center"]Sun 15/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"]...=FREQUENCY(C3:C31,$E$4:$E$16)[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]20[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]21[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]75[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]22[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]23[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]74[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]24[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]68[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]25[/TD]
[TD="class: xl75, align: center"]Sun 22/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]26[/TD]
[TD="class: xl75, align: center"]Sun 29/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]27[/TD]
[TD="class: xl75, align: center"]Sun 29/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]28[/TD]
[TD="class: xl75, align: center"]Sun 29/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]29[/TD]
[TD="class: xl75, align: center"]Sun 29/10/17[/TD]
[TD="class: xl68, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]30[/TD]
[TD="class: xl75, align: center"]Sun 29/10/17[/TD]
[TD="class: xl68, align: center"]78[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="class: xl64, align: center"]31[/TD]
[TD="class: xl73, align: center"]Sun 29/10/17[/TD]
[TD="class: xl74, align: center"]69[/TD]
[TD="align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top