Evilivan

Try two countifs

=COUNTIF($A$1:$C$8,"DB")+COUNTIF($F$1:$Q$10,"DB")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Evilivan" wrote in message
...
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