# 0 values revisited

#### imported_unknown

##### Active Member
No luck with your suggestion. PLease see attached example. (Thanks for your quick response on the first query)
Cheers
Matrix example.xls
ABCDEFGHI
1
2
3
4
5212100,22,0
6221122
723210
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

Replies
2
Views
141
Replies
6
Views
141
Replies
9
Views
223
Replies
2
Views
117
Replies
4
Views
364

1,219,672
Messages
6,149,618
Members
450,904
Latest member
Gracifer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back