Miss Hollywood
New Member
- Joined
- Dec 18, 2005
- Messages
- 3
I have been working on the following and need a little help.
I have col A and Co B. I would like to have a formula that tells me how many rows the combo 1&5 or 2&5 occurs. I got the 1&5 to work earlier (but its on my work computer) but I could not get the "OR" part to work.
I believe I had a sumproduct formula with --
Answer for below would be 4
A B
1 5
2 5
3 7
4 8
5 9
1 5
2 5
3 7
4 8
5 9
If someone could help that would be most wonderful!
I have col A and Co B. I would like to have a formula that tells me how many rows the combo 1&5 or 2&5 occurs. I got the 1&5 to work earlier (but its on my work computer) but I could not get the "OR" part to work.
I believe I had a sumproduct formula with --
Answer for below would be 4
A B
1 5
2 5
3 7
4 8
5 9
1 5
2 5
3 7
4 8
5 9
If someone could help that would be most wonderful!