L

#### laandmc

is satisfied. I want a formular rather like the sumproduct but countproduct

instead.

Please see example below.

I want to count for both companies COMP1 and COMP2 how many non zero cells

there are in the first table, but only when the corresponding cell in the 2nd

table has a "y" in that cell. at the moment I can do this using if functions

with a countif function in the middle. However I am doing this over a period

of 3 years so it makes my formular ridiculously long.

A B C

1 JAN FEB

2 COMP 1 1 2

3 COMP 2 1 0

4

5 JAN FEB

6 COMP 1 y

7 COMP 2 y y

8

9 count none zero with "y"

10 COMP 1 1 <-- =IF(B6="y",COUNTIF(B2,"<>0"),0)+IF(C6="y",COUNTIF(C2,"<>0"),0)

11 COMP 2 1 <-- =IF(B7="y",COUNTIF(B7,"<>0"),0)+IF(C7="y",COUNTIF(C7,"<>0"),0)

I want a way to do it for example = countproduct(b2:c2,(b6:c6="y")*1))

Can anyone help me?? is there another way to do this?

Laurence