cleetus_snow
New Member
- Joined
- Jun 16, 2002
- Messages
- 10
I have seen many great examples of counting using sumproduct. Each has counted based on an AND condition. Can sumproduct be used to count based on an OR condition?
Book6 | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
1 | 0 | 1 | 0 | |||
2 | 0 | 0 | 0 | |||
3 | 0 | 1 | 1 | |||
4 | 0 | 1 | 0 | |||
5 | 1 | 1 | 0 | |||
6 | 0 | 0 | 1 | |||
7 | 1 | 1 | 1 | |||
8 | 0 | 0 | 0 | |||
9 | 2 | 5 | 6 | |||
10 | 2 | 2+3=5 | 5+1=6 | |||
Sheet2 |
cleetus_snow said:Thanks for the link firefytr. I have bookmarked it for future reference.
My data is something like this:
C1 C2 C3
0 1 0
0 0 0
0 1 1
0 1 0
1 1 0
0 0 1
1 1 1
0 0 0
2 5 6
I am trying to calculate a running total (count) for each column. Each new instance of "1" in any column should increase the running total. What do you think?[/img]
cleetus_snow said:Thanks for the link firefytr. I have bookmarked it for future reference.
My data is something like this:
C1 C2 C3
0 1 0
0 0 0
0 1 1
0 1 0
1 1 0
0 0 1
1 1 1
0 0 0
2 5 6
I am trying to calculate a running total (count) for each column. Each new instance of "1" in any column should increase the running total. What do you think?[/img]