Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you use multiple ranges in a function?
I am looking for a function to search through multiple ranges of cells and return a number if it finds any instances of that number. For instance: I have say 6 cells, (A1, C17, F13:G14) and I want to find out if any of them contain the number "1" and if they do, I want the result of B2 to be "1". The way I thought I could accomplish this was to go to cell B2 and do the formula =if(countif((A1,C17,F13:G14),"1")0,1,0) This seems to work for a single range such as =if(countif(F13:G14,"1")0,1,0) I just dont know the proper syntax for including multiple ranges in a function. If anyone knows how to include multiple ranges in a function (if its possible), or knows a simpler way to do what I am trying to do, the help would be greatly appreciated. -- solinar ------------------------------------------------------------------------ solinar's Profile: http://www.excelforum.com/member.php...o&userid=31159 View this thread: http://www.excelforum.com/showthread...hreadid=508216 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a function with multiple criteria | Excel Worksheet Functions | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions | |||
linest won't accept multiple reference ranges | Excel Worksheet Functions | |||
Multiple OR function | Excel Worksheet Functions | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |