Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
=sumproduct((A2:A100="L")*((B2:B100="R"))
-- David Biddulph "Janie" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
Try this in C1:
=SUMPRODUCT(--(A1:A100="R"),--(B1:B100="L")) Adjust the ranges to suit your data. Hope this helps. Pete On Feb 2, 4:29*pm, 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|