Dear Experts,
I am having some values in column A1:A10 with some cell having - (dash). Correspondingly column B1:B10 is also having some values with - related to - in column. To calculate sumproduct of both the columns leaving dashed cell, i type following array formula -
=if(isnumber(A1:A10),sumproduct(A1:A10*B1:B10),"-")
but it is returning #value. If we delete all dashed cell, then it returns only. How to make a round about.
Regards,
Dastgir
If you have also dash in column B you get (also) an error on that.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi
Can you post a smaple file of what you have and show what you want to achieve.
Chris
Click my star if I helped Thanks
Have you tried SUMPRODUCT like this
=SUMPRODUCT(A1:A10,B1:B10)
that will ignore any dashes (effectively treat them like zero)
Audere est facere
Dear Daddylonglegs,
You did me discover a new way of using sumproduct. it really working wonders. thanks a lot.
Regards,
Dastgir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks