Recent content by Debraj

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

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

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

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

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

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

:)

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

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

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

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)))

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

Congrats Somu.. Keep guiding... :)

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

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