I would like to setup a count function that counts by position for specific
type. For example:
Position Type
1 a
2 a
3 c
2 c
3 b
1 a
Function Calculates:
1a = 2
2a = 1
3a = 0
1b = 0
And so on. How can I setup the calculation functions?
Thanks

One way
In C2: =SUMPRODUCT((A$2:A$100=A2)*(B$2:B$100=B2))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KLock" wrote:
I would like to setup a count function that counts by position for specific
type. For example:
Position Type
1 a
2 a
3 c
2 c
3 b
1 a
Function Calculates:
1a = 2
2a = 1
3a = 0
1b = 0
And so on. How can I setup the calculation functions?
Thanks