hi all,
so i had this problem.
i was doing =sumproduct(A1:A10,B1:B10)
however sometimes either a value in A column or B column is blank, so I wanted to ignore that.
I managed to get it to work by using this formula:
=SUMPRODUCT(--(A1:A10),--(B1:B10))
i have no idea what that hyphen hyphen does, can you please help me understand
thanks
There are many explanations of this floating around. Below is a link to one.
Do a forum search for "Double Unary" and you'll find lots of information.
http://www.excelforum.com/excel-gene...-operator.html
I have seen this is a way to convert numbers that are actually text to real numbers....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
I'm not sure I understand the problem...
=sumproduct(A1:A10,B1:B10)
That formula DOES ignore blanks..
Perhaps you just posted a simplified version of a more complicated formula?
Essentially, you are taking a text "value" and converting it to a numeric by giving it a minus sign (-). Then, to convert that back to a positive, you give it another minus sign (yes Bart, 2 wrongs do make a right lol)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks