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

  1. Kimber

    Averageif formula over several columns to exclude numbers based on adjoining cell

    Agreed but using named ranges solves that problem.
  2. Kimber

    Averageif formula over several columns to exclude numbers based on adjoining cell

    Thank you for a streamlined, non-complicated approach that makes sense and works perfectly, Peter.
  3. Kimber

    Averageif formula over several columns to exclude numbers based on adjoining cell

    I have a worksheet with multiple percentages and coordinating description columns. On worksheets with a set of columns, I can use the formula =AVERAGEIFS(C:C,D:D,"<>Not needed"). However, I need to calculate multiple columns -- shown on the attached worksheet with the same status exclusion. I...
  4. Kimber

    Formula to include parentheses in text if applicable

    Thank you so much! I knew that I needed to move the first parenthetical mark but I just could not see it! Appreciate your help so much.
  5. Kimber

    Formula to include parentheses in text if applicable

    I have a cell showing net change -- both numerical and percentage. When positive, it has worked seamlessly, but I have negatives and I cannot find an answer. Basically, the net change is linked to two other calculated cells and an example is +30 (+6.3%) but when the answers are -55 (-10.6%) only...
  6. Kimber

    Track Remaining Amounts with Staggered Dates

    I'll attach what I had before your answer. I am sorry I neglected to upload with my request.
  7. Kimber

    Track Remaining Amounts with Staggered Dates

    Thank you, Peter! I needed to use the entire date so I ended up using the YEARFRAC function. I appreciate your help!
  8. Kimber

    Track Remaining Amounts with Staggered Dates

    A friend has 10 "loans" that will need to be paid back (if he leaves the company) in full the first year, 80% the second year, 60% after three years, 40% after four years, 20% after five years, and 0 after six years. Easy for one date and amount. However, he has roughly ten dates with different...
  9. Kimber

    Excel formula not calculating correctly [SOLVED]

    I am not certain but I will take the blame. I do admit that I was exhausted after having worked on the worksheet for hours.
  10. Kimber

    Excel formula not calculating correctly [SOLVED]

    I love that Excel is logical and that human error is usually the problem. I do not know how to close this question, but I want to thank those who responded. I appreciate your clear thinking and patience.
  11. Kimber

    Excel formula not calculating correctly [SOLVED]

    Thank you, for another prompt response. There were a few cells not included by mistake (but are included on my original sheet.) I am beginning to think my file is corrupt because the file you sent back is working (I get 1455.2 when I select all the appropriate cells to be included.)
  12. Kimber

    Excel formula not calculating correctly [SOLVED]

    Thank you for the response, Hui. I know the totals are incorrect because I checked them after comparing to my accounting department's report totals. The cells I have excluded are included in the subgroup totals. If you hold the CTRL key and click the second row of each "group" (shaded or...
  13. Kimber

    Excel formula not calculating correctly [SOLVED]

    Thank you, AliGW. If you hold the CTRL key and click the second row of each "group" (shaded or non-shaded) and DO NOT INCLUDE the TOTAL SUBGROUPS rows, you will get 1839. I failed to highlight the BUDGET row (row 3) as all of those totals are incorrect as well. As I stated to vletm, the correct...
  14. Kimber

    Excel formula not calculating correctly [SOLVED]

    Thank you for your reply. When I highlight each of the cells referenced in C4's formula, I get a different answer (1455.2.) Actually, row 3 is not totaling correctly, either, as C3 should be 1637.0 rather than 1095.0. I learned about the problem when comparing the total from an accounting...
Back
Top