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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif Function 2
Sumif across a table 1
SumIf - Linked Workbook - #VALUE 1
SUMIFS Between dates that are greater than zero 1
subtotal with sumif nested 1
formula finds values in apparently blank cells 1
SumIf across columns instead of rows 2
IF Function error #VALUE 2

Back
Top