View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Evilivan Evilivan is offline
external usenet poster
 
Posts: 3
Default Counting a single value across multiple cell groups

Hi

1st apologies if this has been asked before, working on a I need connection
in Hungary and don't have ages to search....

I need to count the number occurences of a value (in this case two letter
e.g. "DB") in multiple cell ranges within a worksheet; I am hoping its just a
case of knowing the correct separator within the function - this is the kind
of function I was trying to get work:

=countif(A1:C8[separator here]F1:Q10,"DB")

The problem I am having is with the separator... Help!

Thanks
Ivan