Pb on Countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I would like to do a countif on a separate range: for exemple, I would like th number of times there is 1 in A1:A10 and C1:C10. Is it a way to do it in only one countif ? Because I didn't find how to put the range to be accepted by the formula.I know that I can do a sum of countif but I really want to find how to do it with only one
Thanks for help
Benjamin
 
Ben.c said:
Hi,
I would like to do a countif on a separate range: for exemple, I would
Click to expand...
like th number of times there is 1 in A1:A10 and C1:C10. Is it a way to do
it in only one countif ? Because I didn't find how to put the range to be
accepted by the formula.I know that I can do a sum of countif but I really
want to find how to do it with only one.
Thanks for help
Benjamin
Click to expand...

COUNTIF (and SUMIF) are quite limited functions. As far as I know, you
cannot have a non-contiguous range in these. What's wrong with this?
=COUNTIF(A1:A10,1)+COUNTIF(C1:C10,1)
 
Thanks Paul for the answer...
In fact, the problem is than I have 20 different range. And I just thought that it is long to do countif + countif+...But that's right, it is working and it is, as always, the more important.
Happy Christmas
Benjmain
 
Back
Top