In say, C2: =SUMPRODUCT((A2:A10="R")*(B2:B10="L"))
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Janie" wrote:
I have A with cells various cells marked "R" column B has various cells
Marked "L" -
In Column C - I am trying to write a formula that says basically count if
column A is "R" and column B is "L". In other words, I do not want to count
any cells that do not contain both R & L.

Any help will be appreciated