# a faster way to calculate frequency

is there a way to calculate frequency within a particular interval faster in excel (using some function maybe) bcoz calculating frequency for large datasets manually dosent sound too good thnx

1 answers ( 0 marked as helpful)

Hi Rohan

You can use the function applied in this video to count frequency:

=countif(data_range,"="&the cell number we want to count)