The arrays need to be of equal sizes, you are using D4:D10 which is 1x1
column with
G4:H10 which is 2x1 and so is J4:K10



--


Regards,


Peo Sjoblom

"Deb" wrote in message
...
=COUNTIFS(G$4:H$10,"0",D$4:D$10,"CR")+COUNTIFS(J$ 4:K$10,"0",D$4:D$10,"CR")

Above is my formula based on your advice. I get a "#Value!" when I input
this. What am I doing wrong?
--
Deb


"Max" wrote:

Just some thoughts (applies in my xl03) ..

.. can I use the COUNTIF for a range of columns
Sure, eg like this: =COUNTIF(M:N,A1)

And if its discontiguous, simply use 2 COUNTIF, eg:
=COUNTIF(M:N,A1)+COUNTIF(P:Q,A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Deb" wrote:
New to EXCEL 2007. If I have a 5 column section where each column has
a
different responsiblity or grouping of responsiblites, can I use the
COUNTIF
for a range of columns and not just a range of rows? For example an
LS-I and
LS-II are responsible for colum m,n,p,and Q. LS-II and Closer are
responsible for column O. I need to count the number of exceptions for
the
LS-I individually, the LS-II indivdually and the Closer. Can anyone
help me?

Thanks.
--
Deb