Excel formula doesn't work on formula results

Asked Dec 05 '16 at 19:33

Active Dec 05 '16 at 19:33

Viewed 513 times

I have a range of numbers (Y6:AC6) which are obtained as a function of =RIGHT(Text,Num) formula. When I try to apply COUNTIFS formula on these numbers which you can see on the picture, it doesn't work. However, when I try the same formula on actual numbers, but not functional results of RIGHT(Text,Num), it works. What am I missing here? can someone help me please? thanks.

asked Dec 05 '16 at 19:33

Max

4

precede your Right formula with `--` so: `=--RIGHT(Text,Num)` It will make the text numbers – Scott Craner Dec 05 '16 at 19:35
1

@ScottCraner yes, this solves the problem. Thanks a lot ! but I can't accept your answer in the comment. – Max Dec 05 '16 at 19:41
Thanks for this - I finally understand what `--` means and what it's for. Not sure it's clearer than `Value()` though. – Jack Deeth Dec 05 '16 at 19:44
@JackDeeth not clearer, but less typing. – Scott Craner Dec 05 '16 at 19:45

Excel formula doesn't work on formula results

0 Answers0