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
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 

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

      MatthewLester , so far so good, great to know it fixed

Resources