Adjust the ranges to match--but you can't use whole columns (except in xl2007).
=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.
Bob Phillips explains =sumproduct() in much more detail here:
And J.E. McGimpsey has some notes at:
stumped in texas wrote:
> Can anyone explain how to do a DCOUNTA formula with multiple criteria? I need
> to count the number of people that have PPO insurance that live in Ft. Worth
> or Bedford on a worksheet.