You can also do it without an array formula

=SUMPRODUCT(--(A2:A100="condition1"),--(B2:B100="condition2"))

--
HTH

Bob Phillips

"Mangus Pyke" wrote in message
...
On 18 Jul 2005 08:58:09 -0700, "Egon" wrote:
if I may ask, what does the CTRL+SHIFT+Enter do?

I've never seen that before.

Also called "CSE formulas", this forces Excel to use the data as an
array.

Excel will enter the formula as an array and place curly brackets
around it to identify it as such.

Entering an array by manually including the curly brackets doesn't
work, so Ctrl-Shift-Enter must be used.

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner