Do I need to make a function for each range of cells to search?

Maybe. How many different ranges are there? Are they all the same size?

One way to do it provided all the ranges are the same size and shape:

=IF(SUMPRODUCT(--(A1:A5=B3)+(K16:K20=B3)),"X",0)

Or, if the ranges differ in size/shape, you can always do this:

=IF(COUNTIF(A1:A15,B3)+COUNTIF(K16:AA16,B3),"X","" )

Biff

"Spamn" wrote in message
...
I made a function to search a sheet to match a cell on another sheet.

=IF(COUNTIF(M16M4M203!$O3:$O24,B3)0,"X","")

This works great, but I need it to only search certain cells on the sheet.
I
tried to just select those cells and control-click another group but Excel
tells me "You've entered too many arguements for this function"

Do I need to make a function for each range of cells to search? If so, how
do I put more than one function in a single cell.

Thank you