=SUMPRODUCT((B1:B100<100000)*(C1:C100100))

Notes about SUMPRODUCT: Prior to 2007, you can not use an entire column as
an array (but you can use an entire row...go figure?). Array sizes must all
be the same. As you may guess, you can easily add more criteria to this
function if you wish.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"VPSales" wrote:

I am trying to evaluate a data base of customers where column A lists the
customers by name, column B is annualized sales $, and column C is the
manhours of service per year spent on that account. I want to know how many
customers I have which generated less than $100,000 of sales, and which
required more than 100 manhours of service. I have tried every variation of
"Countif " combined with "and" that I can think of , for example:
=countif(and(b1:b100,"<"&100000),(c1:c100,""&100) )
This is a simplified example, but this is the solution I need. Can anyone
help?