• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by yabi

  1. Y

    How draw graph without filtering?

    Dear Hui Thanks for your reply. I have heard named column or named cell but I haven't heard about named formulas. I will check it in the google.
  2. Y

    How draw graph without filtering?

    I have a table of utility type and their cost. A sample is as follows Utility Date Cost gas Jan. 2013 100US$ gas Feb. 2013 95$ electricity Jan 2013 200US$ electricty Feb 2013 195 $ Telephone Jan 2013 500$ Telephone Feb 2013 300$ gas March 2013 200$ and goes on...
  3. Y

    #value error in sumproduct with Right command

    Just one more question I have to add two sumproduct command in one cell as follows: SUMPRODUCT(--(B$3:B$170=B15);(Q$3:Q$170=$P198)*(S$3:S$170)*(T$3:T$170))+SUMPRODUCT(--(B$3:B$170=B$28);(Q$3:Q$170=$P198)*(S$3:S$170)*(T$3:T$170)) Is there a shorter format to combine --(B$3:B$170=B15) and...
  4. Y

    #value error in sumproduct with Right command

    Dear NARAYANK991 and other folks Many thanks to ARAYANK991 as his solution solved the problem. I was unaware of the difference between "" and zero and assumed both as null. But putting 0 instead of "" solved the problem. May I buy a mug of beer for you. Here is my table Original one H...
  5. Y

    #value error in sumproduct with Right command

    I am trying to use sumproduct function in a table. I have used it a lot and know how it operates. In one of my columns, I have blank cells and other cells are text (like 1F25 in column A). In order to use it in sumproduct, I make two different columns aS FOLLOWS: Column Q...
Back
Top