#1
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...
#5
countif(range,value)
██████████████████████████
████████████████████████
█████████████████████
██████████████████████
█████████████████████
██████████████████████████
██████████████████████████


LET'S GO BUCKS
#7
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
#8
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.
#9
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