A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		DoIf
4
5
6			ListIn	1	2	3
7			ListOut	10	20	30
8
9
10
11		Example 1:		Single Sheet Reference			Range Names
12
13		Sum the values in ListOut for which the corresponding value in ListIn is
14		exactly divisible by 3.
15
16		Operation		Criteria			DoIf
17				mod(?,3)=0			30
18
19
20		Example 2:		Single Sheet Reference			Cell reference
21
22		Sum the values in ListOut for which the corresponding value in ListIn is
23		exactly divisible by 3.
24
25		Operation		Criteria			DoIf
26				mod(?,3)=0			30
27
28
29
30		Example 3:		Multiple Sheet Reference
31
32		Sum the values in ListOut for which the corresponding value is greater
33		or equal to 2.
34
35		Operation		Criteria			DoIf
36				>=2			50
37
38
39
40		Example 4:		Multiple Sheet Reference
41
42		Sum the values in ListOut for which the corresponding value is equal to 2
43		and 2 is in another cell.		2
44
45		Operation		Criteria			DoIf
46				2			20
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80