wrote in message
...
On Mar 11, 2:20 pm, Donald Guillett wrote:
On Mar 11, 6:22 am, wrote:


[ ]
Have used this formula, which is close...but no cigar yet, because
when i drag it across the same results come out for each column!

=SUMPRODUCT(($A$3:$A$14="A")*($B$3:$B$14="1"))

Many thanks for your help,

Simon

=SUMPRODUCT(($A$3:$A$14="A")*(B$3:B$14="1"))- Hide quoted text -

- Show quoted text -

Thanks, but you've just pasted the formula i've already got....any
insight into what i was trying to achieve, something along the lines
of:

=COUNT(($A$3:$A$14="A")*(B$3:B$14="1"))

Cheers, Simon


Take a close look at those two formulas, paying particular attention to
the [ $ ] in them. Don's formula has a critcal distinction from your
formula.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)