| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
making the range a set of data within a column
I have a column with different sets of values. On another worksheet I want
to to make a formula using COUNTIF that states how many times a value from another column in the first sheet appears when a given value is set. Example. In the first sheet in column 1 the number 554 appears 10 times. In another column the values corresponding are in a range of 1-4. On another sheet, I want to do a COUNTIF where the range selected is 554 on the first sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
