insert sumif, shows value of 1709, but displays value 0

  • Thread starter Thread starter Macil
  • Start date Start date
M

Macil

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
 
=sumif(o3:031,"y",p3:p31)

You have one zero and one letter o for the column lertter in the above
equation
 
Back
Top