Neither SUMPRODUCT nor array formulae can do whole columns. The best you can
do is

=SUMPRODUCT(-(A1:A65535="Approved"),-(B1:B65535="Insurance"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"esmer" wrote in message
...
I need a formula to compute same information for an entire column. For
example -sumporduct(-(a1:a10000="Approved"),-(B1:B10000="Insurance")) this
works for a range of cells I need a formula for an entire column.