Hi,

Otherwise, if you DO have multiple conditions, the following ARRAY formula:

=SUM(IF(ISNUMBER(testrange),(testrange5)*(testran ge<40)*testrange))


The previous formula SUM-up the numbers.
If you only want to count them, this ARRAY (Ctrl-Shift-Enter) formula:

=SUM(IF(ISNUMBER(testrange),(testrange5)*(testran ge<40)))


Regards,

Daniel M.