| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating frequency?
I am trying determine how many times a number occurs a five column data
sheet. They are between 1 and 100. I just can't get the formula to give me an answer. Can someone help? Lost in formuland- Thanks- Ken |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating frequency?
Numbers in A1:E100
In F1we have the number 10 In f2 =COUNTIF(A1:E100,F1) tell us how many times 10 appears in A1:B100 What formula did you try? Bernard "Ken" wrote in message ... I am trying determine how many times a number occurs a five column data sheet. They are between 1 and 100. I just can't get the formula to give me an answer. Can someone help? Lost in formuland- Thanks- Ken |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating frequency?
Hi!
One way: Assume your 5 column table is in the range A1:E1000 Enter this formula in G1: =ROWS($1:1) Enter this formula in H1: =COUNTIF(A$1:E$1000,G1) Select both G1 and H1 and copy down to row 100. Biff "Ken" wrote in message ... I am trying determine how many times a number occurs a five column data sheet. They are between 1 and 100. I just can't get the formula to give me an answer. Can someone help? Lost in formuland- Thanks- Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
| Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Linear Mode
