# Recent content by Debraj

1. ### SUM IF S formula help

Try something like this.. =SUMPRODUCT(D2:D2194*(C2:C2194="A")*(A2:A2194="Payment")*(MONTH(B2:B2194)=1))
2. ### 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. ### Look UP Formula

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

Glad that it works.. I am basically asking.. why only 3 data.. not other duration are there..!!
5. ### 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. ### 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..

:)
8. ### filter combobox based on another combobox

Hi Afarag.. subba khair.. Can you please test this one..
9. ### 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..
10. ### 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..
11. ### #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)))
12. ### 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))
13. ### Congratulations Somendra Misra 4,000 Posts

Congrats Somu.. Keep guiding... :)
14. ### 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..
15. ### 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...