MrExcel Publishing
Your One Stop for Excel Tips & Solutions

countif across a series of non-consecutive cells


Posted by Steve on January 25, 2002 4:29 AM

I want to count how many times a student has scored a 4 from a range of cells that do not form an unbroken row - eg C4:G4 and J4:M4 and N4:T4 - is this possible?


Posted by Xcl Mon on January 25, 2002 5:39 AM

Does this solve your problem?
=COUNTIF(C4:G4,4)+COUNTIF(J4:M4,4)+COUNTIF(N4:T4,4)
If the data between your ranges doesnt contain 4's you could just do =COUNTIF(C4:T4,4)
HTH