| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test data in two columns, return totals
Hi,
I would like to test numbers in two columns against each other and count the amount. EG - how many in column A within interval 1 to 2 but only if number in column B (same row) is within interval 3 to 4. Columns are very long and simply want to know how many rows match my criteria. Can do this as a macro, but would like to use worksheet functions. If you know, please tell me the names of the functions that i would need to use. Don't need exact statements unless what I am asking is complex. Eugene |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return the data from 3 columns | Excel Worksheet Functions | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| If value in data range (multiple columns) return row | Excel Discussion (Misc queries) | |||
| test a range of cells and return an adjacent value | Excel Worksheet Functions | |||
Threaded Mode
