| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
including two ranges of cells in an IF formaula
I wish to query two ranges of cells. the cells are on two separate worksheets
in the same workbook, but do not know how to specify more than one range in an IF function. i need the formula to look at both ranges for a particular value the ranges a 'Substance Use'!G9:G71 and 'Mental Health'!G9:G71 please can you advise how to construct the fiormula. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
| Deleting contents of cells in non contiguous ranges | Excel Worksheet Functions | |||
| count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) | |||
| how to combine including blank cells | New Users to Excel | |||
| empty cells in ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
