View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chelle chelle is offline
external usenet poster
 
Posts: 8
Default 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