• 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.

Search results

  1. S

    SUMIFS statement

    Hi sgmpatnaik, Thanks for your help as well.
  2. S

    SUMIFS statement

    Hi NARAYANK991. I have done the two separate SUMIF statements with a plus sign and got the correct answer. I am used to using SUMIF and I thought could this be done using one SUMIFS statement but I see from what you are saying that it cannot be done. So I will stick with using SUMIF. Thanks
  3. S

    SUMIFS statement

    Hi, the following is the formula used and I have included ten amounts in A2 to A11, you should get $9800 as the correct answer.... =SUMIFS(A2:A11,A2:A11,"<"&300,A2:A11,">"&500) $500, $1000, $200, $600, $1200, $100, $5000, $1700, $400, $500
  4. S

    SUMIFS statement

    Hi, I tried both your SUMIFS formulas and still get zero for both. When I do the single SUMIF for 300, I get the right answer..it just doesn't work out when you combine the 300 and 500.
  5. S

    SUMIFS statement

    Thanks for the SUMPRODUCT but I just wanted to know can I do an SUMIFS statement? Is this possible?
  6. S

    SUMIFS statement

    Hi, I have a column of salaries with the data starting in A2 to A200 I need to sum the salaries less than $300 and greater than $500. I can do a SUM in an Array and get the correct answer but I want to do a SUMIFS statement, if possible? I have tried the following but I get zero as the result...
  7. S

    Custom Properties of a workbook

    Hi, just watched the youtube video you recommended, sad to say she did not mention the custom property of the workbook...so still at a loss....thanks
  8. S

    Custom Properties of a workbook

    Hi, I tried that site, but it does not explain what the fields mean or how to use them. I need examples....thanks for helping.
  9. S

    Custom Properties of a workbook

    Hi, I am an intermediate user of Excel 2010 but this is a really basic question for which I cannot find any information about . I have never used the Custom properties tab found within “Info, Properties, Advanced Properties. Can someone please explain why you would use the dropdown fields of...
Back
Top