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" <Deb@discussions.microsoft.com> wrote in message news:28493AFA-FEC8-43E0-9763-8E21862CB887@microsoft.com... =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
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
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
========== ========== james <fsamp...@gmail.com> wrote: Marsh Monster- People don't buy old cars because they're dim, they buy them because they can't afford a new car. I'll be driving crappy cars at least until graduation (2 years). �Your advice helps you (by giving you the opportunity insult people anonymously) but unfortunately doesn't help me. I tried selling it as-is for $700
