Try the following instead...

=COUNTIF(D2:O10,"Abs")/SUMPRODUCT(--(ISNUMBER(MATCH(D2:O10,{"A","B","C","D","E","F","G ","U","Abs"},0))))

OR

=COUNTIF(D2:O10,"Abs")/MAX(SUMPRODUCT(--(ISNUMBER(MATCH(D2:O10,{"A","B","C","D","E","F","G ","U","Abs"},0)))),1)

...which will return a 0 instead of a #DIV/0 error when the denominator
evaluates to 0.

Hope this helps!

Marie1uk Wrote:
The 2440 was a hypothetical example to illustrate what I wanted, not the
exact number of grades that the spreadsheet will contain - sorry for the
confusion. The spreadsheet needs to count all cells that have abs in
them in a specified range and then divide by those cells that contain
A*, A, B, C, D, E, F, G, U & Abs to arrive at a % of abs marks out of
all possible grades.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=384303