No need for array formulae, these are normal ones:

=SUMPRODUCT(--(A2:A70),--(ISBLANK(B2:B7)))

=SUMPRODUCT(--(A2:A70),--(ISBLANK(B2:B7)),A2:A7)

Adjust ranges!

--
Regards!
Stefi



€žnelly€� ezt Ã*rta:

Hi Guys

I need an array formula which counts the number of instances range Comp1 has
a value greater then zero AND Range Comp2 has a blank value.

Sounds simple but I just can't figure it out.

Also would be helpfull would the same criterior but instead of counting the
instances sums the vales in range Comp1

A B
1 1
3
1 2
1 1
1
4 4

Answer for formula 1 would be 2

and for formula 2 would be 4

Regards
Nelly