Hi,

Am Tue, 26 Mar 2013 19:07:31 +0100 schrieb Claus Busch:

these values only will be counted if the cell in C, AH /and/ AO in the
same row are not empty.

if you want to count the values in AP8:AR107 <= 500 without any other
condition, then try:
=COUNTIF(AP8:AR107,"<=500")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2