Look in help for COUNTIF and FREQUENCY, help explains both formulas well


Regards,

Peo Sjoblom

"kate" wrote:

I want to count the frequency of a number in a series of numbers possibly
using a count if or lookup function. I wish the total number to be displayed
at the bottom, how can i do this?