Hi,

You can use the DCOUNT() function. Assume A18 has "column 1" and Y18 has
"column 2" (w/o quotes)

In cell A359 type, "column 1" and in B359 type "column 2". In A360, type
the text which you have in A7, In B360, type 1. Now in C360, use the
following DCOUNT() formula:

=DCOUNT(A18:Y359,A18,A359:B360)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Chris" wrote in message
...
Is there any way to replicate this formula with countif or sumif and
not using the array (ctr shift enter) function?

=SUMPRODUCT((A19:A357=A7)*(Y19:Y357=1))