excel sheet calculation of frequency

Copper Contributor

I am Not able to calculate frequency as every time I am using the formula =Freqeuncy(data array, bins array) I am always getting 0 as the result or if I am getting Some result than it is repeating for every values

 

2 Replies
Nobody helping here as a (working) crystal ball
Could you post a sample of your data + the expected result at least please?

@Victoria_Fernandez 

=FREQUENCY(B2:B10,C2:C4)

This formula works in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

frequency.JPG