Hi Kristin,

Show us the formula. If the number are entered as numbers and you test for
numbers then things should work. So we need to see what you are entering as
a formula.
--
Thanks,
Shane Devenshire


"Kristin" wrote:

I am trying to use SUMPRODUCt to count the number of occurance within 3
different criteria. Everything has been working great until I want one of
the arrays to include a column that is formatted for dollars and numbers. If
I individually change the dollars and numbers to text the formula works but
this is extremely time consuming and really a big waste of time. I have
tried selecting the entire column and adjusting the formatting but that
doesn't work...only changing each cell individually works. Please help!
--
kristin