Go Back   UG Community @ Ultimate-Guitar.Com > UG Community > The Pit
User Name  
Password
Search:

Reply
Old 09-15-2014, 05:49 PM   #1
liampje
UG Addict
 
liampje's Avatar
 
Join Date: Jun 2009
what function in excel

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...
liampje is offline   Reply With Quote
Old 09-15-2014, 05:50 PM   #2
amsterdamankl
A Rat Tomago
 
amsterdamankl's Avatar
 
Join Date: Jul 2013
Location: In Repose
your mom
__________________
Quote:
Originally Posted by Xiaoxi
pitters gon pit
amsterdamankl is offline   Reply With Quote
Old 09-15-2014, 05:51 PM   #3
Weaponized
Registered User
 
Join Date: Mar 2011
what version of excel do you have?
__________________
Quote:
Originally Posted by crazysam23_Atax
Is the officer going to ask for the butt, so he or she can check whether it is hot?


last.fm
Weaponized is offline   Reply With Quote
Old 09-15-2014, 06:05 PM   #4
liampje
UG Addict
 
liampje's Avatar
 
Join Date: Jun 2009
Quote:
Originally Posted by Weaponized
what version of excel do you have?

I run 2013.
liampje is offline   Reply With Quote
Old 09-15-2014, 06:23 PM   #5
AeroRocker
I'm too old for this ****
 
AeroRocker's Avatar
 
Join Date: Oct 2007
Location: OH-
countif(range,value)
__________________
██████████████████████████
████████████████████████
█████████████████████
██████████████████████
█████████████████████
██████████████████████████
██████████████████████████


LET'S GO BUCKS
AeroRocker is offline   Reply With Quote
Old 09-15-2014, 06:26 PM   #6
liampje
UG Addict
 
liampje's Avatar
 
Join Date: Jun 2009
Will check it out tomorrow. Thank you very much!!
liampje is offline   Reply With Quote
Old 09-15-2014, 06:32 PM   #7
AeroRocker
I'm too old for this ****
 
AeroRocker's Avatar
 
Join Date: Oct 2007
Location: OH-
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
AeroRocker is offline   Reply With Quote
Old 09-15-2014, 06:55 PM   #8
liampje
UG Addict
 
liampje's Avatar
 
Join Date: Jun 2009
Quote:
Originally Posted 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.
liampje is offline   Reply With Quote
Old 09-15-2014, 07:55 PM   #9
Cb4rabid
Scheiße
 
Cb4rabid's Avatar
 
Join Date: May 2009
Location: Florida
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
__________________
Quote:
Originally Posted by BladeSlinger
It's people like you that make this stuff frustrating.


You don't understand this? How about now? Why don't you understand? This is so easy 4y(20x) graph it fggt

#teamLAD
Cb4rabid is offline   Reply With Quote
Reply


Thread Tools Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -4. The time now is 11:45 AM.

Forum Archives / About / Terms of Use / Advertise / Contact / Ultimate-Guitar.Com © 2014
Powered by: vBulletin Version 3.0.9
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.