Forum Discussion

Jeremy Punnett's avatar
Jeremy Punnett
Copper Contributor
Oct 08, 2018
Solved

Sumif formula need help

I am trying to learn SUMIF. The examples given on the online examples are coming out as 0 on my spreadsheet? Both 1 and 2? Even though the function is working in another workbook. As I am trying to u...
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Oct 08, 2018

    Hi Jeremy,

     

    Please provide us with a sample of the date in your spreadsheet to be able to figure out what is the problem!

     

    Anyway, the common cause of this issue is that the numbers in the Sum Range are in the text format as the below example:

     

     

    Please find the attached file

     

    Regards,

    Haytham

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 08, 2018

Hi Jeremy,

 

Please provide us with a sample of the date in your spreadsheet to be able to figure out what is the problem!

 

Anyway, the common cause of this issue is that the numbers in the Sum Range are in the text format as the below example:

 

 

Please find the attached file

 

Regards,

Haytham

Jeremy Punnett's avatar
Jeremy Punnett
Copper Contributor
Oct 08, 2018

Hi 

Thanks for the response. I have got SUMIF to work on the spreadsheet for work I need but I cannot understand why this isn't working when I copied from MS site? It's bugging me and makes me think I have missed something bigger. The is clearly going to be a schoolboy error.

Thanks for your help.

KR/

Jeremy

Resources