• 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


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

  1. Debraj

    SUM IF S formula help

    Try something like this.. =SUMPRODUCT(D2:D2194*(C2:C2194="A")*(A2:A2194="Payment")*(MONTH(B2:B2194)=1))
  2. Debraj

    Excel 2003-2010

    Are you sure.. you have uploaded the correct file, As i am unable to find mentioned formula anywhere in the file.. =SUMPRODUCT((M$4:M$23=M4)*(L$4:L$23>L4)) and everything looks fine..
  3. Debraj

    Look UP Formula

    Cross posted and Solved.. http://www.excelforum.com/excel-general/1063986-look-up-formula.html Please stop CROSS POSTING
  4. Debraj

    Return Data from table

    Glad that it works.. I am basically asking.. why only 3 data.. not other duration are there..!!
  5. Debraj

    Return Data from table

    Did you tried.. =INDEX('Daily Light'!B2:O26,MATCH(Information!$C13,'Daily Light'!A2:A26),MATCH(Information!C11,'Daily Light'!B1:O1,0)) PS.. Do you have any valid reason.. why data validation is from sheet 2..
  6. Debraj

    Congratulations Narayan 10,000 Posts

    Its an pleasure to share the same platform with you.. A big salute for all your help for this community..
  7. Debraj

    filter combobox based on another combobox

    Hi Afarag.. subba khair.. Can you please test this one..
  8. Debraj

    Problem with Countif and Sumif

    Hi.. Welcome to the forum.. In case of Count.. You can use Countifs.. =COUNTIFS($B$9:$D$20,$F9) and in case of Sum.. Try this.. =SUM(MMULT(TRANSPOSE(IFERROR(MATCH($B$9:$D$20,F9,0),0)),$A$9:$A$20)) Confirm the formula by pressing Ctrl+Shift+Enter.. Not Just Enter..
  9. Debraj

    Excel Area Chart a possible?

    Hi Gerhard.. As you have already got the overlap issue.. here is a solution.. http://peltiertech.com/area-chart-invert-if-negative/ Try to adapt.. or let us know..
  10. Debraj

    #REF Error with Index & nested Match Formula

    Hi Amanda.. Welcome to the forum.. try this.. In H2.. =IF(INDEX(Payment[Paid Date],MATCH([@Invoice],Payment[REFERENCE],0))=0,"",INDEX(Payment[Paid Date],MATCH([@Invoice],Payment[REFERENCE],0)))
  11. Debraj

    Need to sum data as per value define

    if you can sort the table.. then it will be much easier to sum.. like this. =SUMPRODUCT(LOOKUP(D2:D19,A2:B6))
  12. Debraj

    Congratulations Somendra Misra 4,000 Posts

    Congrats Somu.. Keep guiding... :)
  13. Debraj

    Average Between Dates & Exclude 0

    Its AverageIfS You can add many more validation in the same.. =AVERAGEIFS($I$11:$I$486,$B$11:$B$486,">="&M6,$B$11:$B$486,"<="&N6,$I$11:$I$486,">0") and regarding Processing speed.. much faster than SUMPRODUCT.. and long range..
  14. Debraj

    Scrolling Shape

    Hi Portucale.. To float the same using SCROLL is lil bit difficult, you may have to use CLASS / API to track scroll movement.. However, if Selection change, it can be done.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim r As Range Set r = ActiveWindow.VisibleRange.Cells(1...