count the production result and making the date in text format

B

Biff

Hi aboiy,

You can use a formula like this to get the qty:

=SUMPRODUCT((Sheet1!B7:D9="BD306")*1)

How you get all the design codes in a verticle column
without repeats will take some work!

Biff
 
A

aboiy

Biff,

Thank you so much.

Do you have any comments on my second question?

the month to appear only as 'October,2003'
basing on =today() or =now().

aboiy
 
P

Paul

aboiy said:
Biff,

Thank you so much.

Do you have any comments on my second question?

the month to appear only as 'October,2003'
basing on =today() or =now().

aboiy
Click to expand...

Put =TODAY() in the cell and format it as mmmm,yyyy
 
Top