Hi
The sumifs formula in C6 is not working since I have started trying to use with trimmed data. The reason for trimming is that sometimes the data will have the dashes between numbers and sometimes not, or maybe there is another way to over come this.
Example below.
Any ideas would be greatly appreciated.
Thanks in advance
Hi shrubfact,
Look at the attached where I've converted the texts in column I to values by adding a zero to them. Also your ">" and "<" were backwards.
Add zero to make values from strings and GT LT switch.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi MarvinP,
Brilliant...looks perfect
Thankyou so much
Try this
Formula:
Please Login or Register to view this content.
formula will return 34
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks