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