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

    Adding Multiple Columns using multiple criteria

    Thank you for trying to help me. I will look into it. Thanks so much
  2. R

    Adding Multiple Columns using multiple criteria

    Hi Thank you for letting me know about this. T
  3. R

    Adding Multiple Columns using multiple criteria

    Hi I need some help on a formula in cell E17 of the Summary Tab of the attached spreadsheet which will sum all the amounts for the 6 months for ‘Short Term Care’ for the ‘Metro’ area for the year FY 2023 by looking up all the values and descriptions in the ‘Output-Detailed Costs. Similarly for...
  4. R

    When an amount reaches a max amount then zero after that

    I dont understand why you are using such language against genuine people like me. Have you got something against me?
  5. R

    When an amount reaches a max amount then zero after that

    Thanks. I will share it here. Thank you
  6. R

    When an amount reaches a max amount then zero after that

    Thank you so much for your reply and sharing your knowledge. Much appreciated.
  7. R

    When an amount reaches a max amount then zero after that

    Thank you so much for your reply
  8. R

    When an amount reaches a max amount then zero after that

    Thank you so much Although have never seen a formula like this. Cheers for your help
  9. R

    When an amount reaches a max amount then zero after that

    I have tried a formula in the attached sheet but it doesnt work. If someone can please help. Thank you
  10. R

    When an amount reaches a max amount then zero after that

    Hi Guys I need help on a formula. In the attached spreadsheet i need a formula say starting from cell C6 which says if the amount in that cell reaches total loan amount of $8m then the next cell to cell d7 should be zero. Please help
  11. R

    Sum values with multiple criteria

    Just for your knowledge. I finally managed to find a solution to my formula. There was no need of pivots. This is the simple formula. Perhaps may assist you in the future. =SUMIFS(Costs!H$6:H$219,Costs!$B$6:$B$219,$C5,Costs!$C$6:$C$219,$D$2)
  12. R

    Sum values with multiple criteria

    Thanks very much
  13. R

    Please help - Sum amount with various conditions or criteria

    Hi. Please can someone help me. In the attached spreadsheet, i am looking for a formula in the summary tab in cell E13 which will look at the value or text in cell C6 (summary tab) then compare it to the range of the same value or text in the costs tab from cells C6:C219 and also look at the...
  14. R

    Sum values with multiple criteria

    The whole purpose a formulae is not provided is because i dont have one. Hence i am asking for help. Regarding effort from my part, i would not be reaching out had i not tried before. Whether its an assignment or not, what does it matter. This is a platform to assist people in excel. Anyway thanks.
  15. R

    Sum values with multiple criteria

    Thank you for your reply. This is not a trap but something work related that i am stuck on. Besides i thought this forum was to assist those who need assistance on excel regardless of what it is. Thanks
  16. R

    Sum values with multiple criteria

    Hi. In the attached spreadsheet, i am looking for a formula in the summary tab in cell E13 which will look at the value or text in cell C6 (summary tab) then compare it to the range of the same value or text in the costs tab from cells C6:C219 and also look at the value in summary tab cell c12...
  17. R

    Timing of Purchase and return value in corresponding year

    Thanking you so much my friend. Excellent and works well.
  18. R

    Timing of Purchase and return value in corresponding year

    Hi I am trying to get a formula in say cells D4 to R4 which will return the value in cells B7 to B11 based on the year it occurred. Say for example from data highlighted in the table in orange (from Cells A7 to B11) in year 3 5 units were sold therefore this number should appear in cell F4...
  19. R

    Sumif Rows and Column with Data Validation Drop Down

    Thank you so much Somendra. Bless
  20. R

    Sumif Rows and Column with Data Validation Drop Down

    You are a genius. This works perfectly. Well done and thank you so much for taking the time out here to help. Thank you.
  21. R

    Sumif Rows and Column with Data Validation Drop Down

    In the attached spreadsheet i want a formula total amount amount in cell d10 which reflects the month in cell d7. So far example if D7 is April 20 then the formula should look at rows d14 to l14 (months) and sum everything in that column. For now i have manually inserted the amount.
  22. R

    Timing of Purchase Formula

    Thats Fantastic Works wonders. Didnt know such a simple formula would do the trick. Thank you for this brilliant reply. Regards
  23. R

    Timing of Purchase Formula

    Hi all I needed help on a formula. In the attached spreadsheet i have in cells c3 to c6 the time when a purchase is intended to be made and in cells d3 to d6 the amount. In cells from e10 to n13 i want a formula that will pick the time the purchase is intended to be made and put the...
  24. R

    Pick value each month until maximum is met

    Thank you so much my friend. Really good and very different. Well done. You are a genuis. Thank you.
  25. R

    Pick value each month until maximum is met

    Thank you Bosco. You are a legend. An absolute genius. Thank you.
Back
Top