On Mar 11, 2:20*pm, Donald Guillett wrote:
On Mar 11, 6:22*am, wrote:





I'm trying to count no. values in a column if 2 conditions apply.
Thanks to these discussions I've figured out how to SUM the PRODUCTS
in the column, but now i want to COUNT them!

Example:

* * * * * * * * No bills/month
Name * *House * Jan-11 *Feb-11 *Mar-11
A * * * 1 * * * 4 * * * * * * * 3
A * * * 2 * * * 2 * * * 2
A * * * 3 * * * 2
A * * * 1 * * * 3 * * * 1 * * * 2
B * * * 2
C * * * 3 * * * 1 * * * 4
C * * * 1 * * * 6 * * * * * * * 3
C * * * 2 * * * 4 * * * 2
C * * * 3 * * * 2
C * * * 1 * * * 1 * * * * * * * 3
C * * * 2 * * * 3
C * * * 3 * * * 2 * * * 5 * * * 4

and i want to COUNT how many bills/month, per House and per Name....to
create:

* * * * * * * * Jan-11 *Feb-11 *Mar-11
A * * * 1 * * * 2 * * * 1 * * * 2
A * * * 2 * * * 1 * * * 1 * * * 0
A * * * 3 * * * 1 * * * 0 * * * 0

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