0 values revisited

[imported_unknown]

No luck with your suggestion. PLease see attached example. (Thanks for your quick response on the first query)
Cheers

Matrix example.xls
	A	B	C	D	E	F	G	H	I
1
2
3
4
5		21	2	1	0		0,22,0
6		22	1	1	22
7		23	2	1	0
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

 

[eliW]

hi geotay,
The problem is with your formula which
SUMs FALSE to give (0)

Try this formula to get the same result:

=IF(AND(C5=1,D5=1),B5,"")

in E5 and copy to all other cells.

Good luck,

Eli
This message was edited by eliW on 2002-10-07 04:20