Formula Help

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

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.
 
=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?
 
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
 
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.
 
Back
Top