View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jovan Timotijevic[_2_] Jovan Timotijevic[_2_] is offline
external usenet poster
 
Posts: 12
Default Formulas in Excel Worksheet



Ok. Try this array formula (or if it doesn't work for you send me a copy of
woorkbook to

send.excel <at gmail.com


=COUNTIF(Worksheet3!$I$2:$I$7,""&B2)*($A$2:$A$7=W orksheet3!$A$2:$A$7)

I assumed that you have 7 rows of data, change it in your formula.