View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Macil Macil is offline
external usenet poster
 
Posts: 4
Default insert sumif, shows value of 1709, but displays value 0


use insert function sumif, as typing in auguments , shows that the value of
function is 1,709. but displays value of 0. when trying to evaluate
formula, will not evaluate auguments separately, but evaluated entire
formuala as 0. formula is =sumif(o3:031,"y",p3:p31)
Macil