Robertson1995
Board Regular
- Joined
- Apr 1, 2009
- Messages
- 121
Im sure this is a simple formula, but I cant figure it out. Here's the data I have:
*The same data may appear numerous times in each Column.
Column A = site # (600-799)
Column B = freq # (384, 426, 510, or 636)
Column C = sector (Alpha, Beta, or Gamma)
What is need is a formula to count how many times Column A=600 B=384 & C=Alpha, or Column A=600 B= 426 & C=Alpha, etc. and repeat for each site.
*The same data may appear numerous times in each Column.
Column A = site # (600-799)
Column B = freq # (384, 426, 510, or 636)
Column C = sector (Alpha, Beta, or Gamma)
What is need is a formula to count how many times Column A=600 B=384 & C=Alpha, or Column A=600 B= 426 & C=Alpha, etc. and repeat for each site.