Forum Discussion

MatthewLester's avatar
MatthewLester
Copper Contributor
Aug 21, 2019

Sumif not working with Text

I can't get sumif to work with text (I normally can). I have tried cell reference and "text" in the selection criteria in the formula. It will not work until I change the selection criteria data to a...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 21, 2019

MatthewLester 

Perhaps your criteria range is formatted as numbers. Could you submit small sample file?

  • MatthewLester's avatar
    MatthewLester
    Copper Contributor
    Aug 21, 2019

    Thanks - I think I have checked that

    How do I submit a file?

     

    SergeiBaklan 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 21, 2019

      MatthewLester 

      Click on this item at the bottom left of Reply window and select the file to attach.

      • MatthewLester's avatar
        MatthewLester
        Copper Contributor
        Aug 21, 2019

        Ah - thanks - I have found the problem. Hidden rows with matching negative entries - it was working but totalling zero. Arrgghhh! 

         

        thanks for your help

         

        SergeiBaklan 

Resources