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

Counting a single value across multiple cell groups
 

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

Counting a single value across multiple cell groups
 

Hey Nick

Thanks for the quick reply - on Xmas eve no less (if that means anything to
you of course), will give it a try but it sounds like it should work - I
didn't know you could double up the "count if's".

Cheers
Ivan

"Nick Hodge" wrote:

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

Counting a single value across multiple cell groups
 

Yep...Christmas is good here..should work for you...

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


"Evilivan" wrote in message
...
Hey Nick

Thanks for the quick reply - on Xmas eve no less (if that means anything
to
you of course), will give it a try but it sounds like it should work - I
didn't know you could double up the "count if's".

Cheers
Ivan

"Nick Hodge" wrote:

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

Counting a single value across multiple cell groups
 

....and work it did. Merry Christmas Nick, and thanks again for your help.

Ivan

"Nick Hodge" wrote:

Yep...Christmas is good here..should work for you...

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


"Evilivan" wrote in message
...
Hey Nick

Thanks for the quick reply - on Xmas eve no less (if that means anything
to
you of course), will give it a try but it sounds like it should work - I
didn't know you could double up the "count if's".

Cheers
Ivan

"Nick Hodge" wrote:

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