What are the conditions?

=SUMPRODUCT(--(ISTEXT(Range1)),--(Range2=1),--(Range3=2))

as an example but you need to be more specific

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Bec" wrote in message
...
What would my formula look like if I had 2 conditions that needed to be
met
and then for any that met that condition to count those instances, in this
case it is all text entries.

Thanks
Bec