Formula Help
 

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

Formula Help
 

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

Formula Help
 

=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

Formula Help
 

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

Formula Help
 

So if I am looking at the same range for 4 different columns, i.e.
G4:G10/H4:H10/J4:J10, and K4:K10 do I need to use individual "COUNTIFS" and
add together? The D4:D10 column is the person responsible so the CR must
also be associated with the row before it should be counted.
--
Deb


"Peo Sjoblom" wrote:

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