Show the contents of certain cells if....

  • Thread starter irresistible007
  • Start date
I

irresistible007

Dear All,

I have been working around for more than few weeks for the belo
shit.... 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 eithe
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 b
payable by next Month so I got the following formula (from web... whic
i still could understand how workes cuz me cant understand th
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 paymen
will be payable next month, seperated by (,) (or in other words..
Invoice nos. for which the above formula calculated the total payabl
amount)

Awaits for u ppl to respond
 
R

Roger Govier

Hi

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

Regards

Roger Govier
 
Top