View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Spamn Spamn is offline
external usenet poster
 
Posts: 6
Default =IF(COUNTIF to search several groups of cells

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