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

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

=sumif(o3:031,"y",p3:p31)

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

"Macil" wrote:


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