Formula help

[Janie]

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

 

[David Biddulph]

=sumproduct((A2:A100="L")*((B2:B100="R"))

 

[Pete_UK]

Try this in C1:

=SUMPRODUCT(--(A1:A100="R"),--(B1:B100="L"))

Adjust the ranges to suit your data.

Hope this helps.

Pete

 

[Max]

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