Forum Discussion
Victoria_Fernandez
Apr 23, 2023Copper Contributor
excel sheet calculation of frequency
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 fo...
OliverScheurich
Apr 23, 2023Gold Contributor
=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.