Show the contents of certain cells if....
 

Dear All,

I have been working around for more than few weeks for the below
****.... cuz i didnt found any relevant info so i joined this web...
plz help me out!!

I am having a sheet listing the details of Orders which are either
completed or are under process like Lets say:

... I1=Amount, J1=Invoice no., M1= Due date, N1=Status

I first required to get the sum of all the payments which will be
payable by next Month so I got the following formula (from web... which
i still could understand how workes cuz me cant understand the
formula... but anyhow this worked 4 me...)

=SUMPRODUCT(--(N4:N90="Matured"),--(M4:M90<=VALUE("10/15/2005")),--(I4:I90))

What i want now is to list those Invoice nos. against which the payment
will be payable next month, seperated by (,) (or in other words...
Invoice nos. for which the above formula calculated the total payable
amount)

Awaits for u ppl to responde


--
irresistible007
------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2253531

Hi

I think the easiest way to show these line is to use Autofilter.
DataFilterAutofilter and select the drop down on column M
Choose Custom and select the dates you want to include.

Regards

Roger Govier



irresistible007 wrote:

Dear All,

I have been working around for more than few weeks for the below
****.... cuz i didnt found any relevant info so i joined this web...
plz help me out!!

I am having a sheet listing the details of Orders which are either
completed or are under process like Lets say:

... I1=Amount, J1=Invoice no., M1= Due date, N1=Status

I first required to get the sum of all the payments which will be
payable by next Month so I got the following formula (from web... which
i still could understand how workes cuz me cant understand the
formula... but anyhow this worked 4 me...)

=SUMPRODUCT(--(N4:N90="Matured"),--(M4:M90<=VALUE("10/15/2005")),--(I4:I90))

What i want now is to list those Invoice nos. against which the payment
will be payable next month, seperated by (,) (or in other words...
Invoice nos. for which the above formula calculated the total payable
amount)

Awaits for u ppl to responde