Forum Discussion

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

Diamond Contributor

Aug 21, 2019

MatthewLester

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

MatthewLester

Copper Contributor

Aug 21, 2019

Thanks - I think I have checked that

How do I submit a file?

SergeiBaklan

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
  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
    Diamond Contributor
    Aug 21, 2019
    MatthewLester , so far so good, great to know it fixed