Part7.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 1 | 2 | 3 | 4 | ||||
2 | 2 | 2 | 2 | 4 | 8 | |||
3 | 3 | 3 | 3 | 4 | ||||
4 | 1 | 1 | 1 | 4 | 8 | |||
5 | 2 | 2 | 2 | 4 | ||||
6 | 1 | 2 | 3 | 4 | ||||
7 | 2 | 2 | 2 | 4 | ||||
8 | 3 | 3 | 3 | 4 | ||||
9 | 1 | 1 | 1 | 4 | ||||
10 | 2 | 2 | 2 | 4 | ||||
11 | 1 | 1 | 1 | 4 | ||||
12 | 2 | 2 | 2 | 4 | ||||
13 | 3 | 3 | 3 | 4 | ||||
14 | 1 | 1 | 1 | 4 | ||||
15 | 2 | 2 | 2 | 4 | ||||
16 | 1 | 1 | 1 | 4 | ||||
17 | 2 | 2 | 2 | 4 | ||||
18 | 3 | 3 | 3 | 4 | ||||
19 | 1 | 1 | 1 | 4 | ||||
20 | 2 | 2 | 2 | 4 | ||||
21 | ||||||||
22 | ||||||||
23 | ||||||||
24 | ||||||||
25 | 1 | 2 | 3 | |||||
Sheet3 |
On 2002-10-24 23:52, cblake wrote:
I'm trying to get the proper format for a SUM formula with 3 conditional IF statements. Is it this?
=SUM(IF($A$1:$A$20=A25,IF($B$1:$B$20=B25,IF($C$1:$C$20=C25))),$D$1:$D$20)
The idea is to sum figures in column D, if 3 conditions are met.