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