View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sierra spiegel sierra spiegel is offline
external usenet poster
 
Posts: 18
Default counts repeated number in two different area only once

I have a formula that count repeat number only once, but in the same area only:

IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9)0,1, 0)

I want to count all the repeats to A1 in both area only once.

thanks


EggHeadCafe - Software Developer Portal of Choice
MDI Inter-Form Communication with Events
http://www.eggheadcafe.com/tutorials...ommunicat.aspx