The SUMPRODUCT function can be used for both summing and for counting.

You could also use a =SUM(IF(... array formula construction.

If you have XL2007 or later then you could use the COUNTIFS function.

Hope this helps.

Pete

On Mar 15, 5:35*pm, wrote:

Thanks for your response Clif, but I did notice that - and having
tried Don's formulae these happen:

a) there's no difference from my example
b) when i drag the formula across to the right it drags the " B$3:B
$14="1")) " with it....ie creating, for example, " F$3:F$14="1"))
"....which i don't want.

Not sure if i explained the context correctly, but i want the 2
conditions to remain the same - ie these bits: (($A$3:$A$14="A")*(B$3:B
$14="1")). They are fine!
What i want to do is COUNT the values in the table when these 2
conditions are true...not SUM, SUMPRODUCT, SUMIF.

Any other suggestions?

Cheers, Simon