Thanks again.
H,J,L are not always in ascending order, so I need to use the 2nd formula.. but I have tried it and I always get a 0 result. Any ideas?
By the way, I'm located in Russia but my laptop is from US and Excel is US-based... I use a semicolon as a delimiter.
Sounds like the numbers are in fact stored as text.
SUM will not explicitly coerce -- eg
A1 holds "0" as text and B1 "10"
SUM(A1:B1) -> 0
whereas
A1+B1 returns 10
the latter is explicitly coercing the text values to numbers via addition.
Why use SUM ?
Well I used SUM on the off chance the cells contained values that could not be coerced without error eg
A1: "Apple"
B1: 10
=SUM(A1:B1) --> 10
whereas
=A1+B1 -> #VALUE! as "Apple" can not be coerced to Number
Better to enter numbers as numbers.
If you can, post a sample.
Regards delimiter - this is based on the client locale
(ie as determined by the Regional Settings [Control Panel]).
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks