Return only certain value of selected cells

[Goddess]

Hi,

I have a sheet similar to below:

Sheet1 (data source)

	A	B	C	D	E	F
1​	Name	May	Jun	Jul	Aug	Sep
2​	Ali	4	6	-7	-8	0
3​	Mary	-7	8	7	-10	-5
4​	Jane	ok	ok	5	-7	-7
5​	Lim	7	-8	9	7	9
6​	Tan	4	ok	-4	4	7
7​	Muthu	-8	6	-8	0	10

Result that I want is that it only returns certain names, with values that are below 0. If the value of the selected name is 0 and above, or if it contains text, it will leave the cell blank.

Sheet2 (result)

Name	May	Jun	Jul	Aug	Sep
Jane				-7	-7
Lim		-8
Muthu	-8		-8

Thanks!

 

[Goddess]

Hi.. sorry... some modification to my original post (not sure how to edit or cancel the original post. SORRY!)

Source file (Sheet1)

	A	B	C	D	E	F
1​	Name	No.	May	Jun	Jul	Aug	Sep
2​	Ali	3	4	6	-7	-8	0
3​	Mary	4	-7	8	7	-10	-5
4​	Jane	1	6	ok	5	-7	-7
5​	Lim	2	ok	-8	9	7	9
6​	Tan	2	4	0	-4	4	7
7​	Muthu	3	-8	6	-5	7	10

Selected names (as below), will show value below 0. Anything 0 and above, or with text, it'll return a blank cell. Also, the value need to multiply by the number in column B.

Result file (Sheet2)

Name	May	Jun	Jul	Aug	Sep
Jane				-7	-7
Lim		-16
Muthu	-24		-15

Thanks!