Hello there pit,

Maybe a bit of an odd question. But what function in excel do I use to count the frequency in a table of a value between x and y. The option frequency doesn't work...
what version of excel do you have?
Quote by Weaponized
what version of excel do you have?

I run 2013.
countif(range,value)
██████████████████████████
████████████████████████
█████████████████████
██████████████████████
█████████████████████
██████████████████████████
██████████████████████████

LET'S GO BUCKS
Will check it out tomorrow. Thank you very much!!
Sorry I might have misread the question. If you wanted to find the number of entries that are, for example, between 3 and 7 you could do:

COUNTIFS(range,"<=7",range,">=3")

where

COUNTIF(range, 7) would give you the number of times 7 appears in the list
██████████████████████████
████████████████████████
█████████████████████
██████████████████████
█████████████████████
██████████████████████████
██████████████████████████

LET'S GO BUCKS
Quote by AeroRocker
Sorry I might have misread the question. If you wanted to find the number of entries that are, for example, between 3 and 7 you could do:

COUNTIFS(range,"<=7",range,">=3")

where

COUNTIF(range, 7) would give you the number of times 7 appears in the list

I need the first one. But I really appreciate it that you take the effort.
i took a course in excel and access last semester online

I passed that class with a C+. I still have no idea how to use either programs because i just googled all of the solutions and answers to the tests

just wanted to share how useless I am
pinga