sum with multiple criteria
Yes I need to sum the values in column B
--
Chelle
"Peo Sjoblom" wrote:
Text maybe, what happens if you test the values with =ISNUMBER(A1)
=ISNUMBER(B1)
then copy down as long as needed to cover the values in A and B
if you get any false then you have text and I showed how you could correct
that unless you want to sum the values as opposed to count them
--
Regards,
Peo Sjoblom
|