| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel formula
I am using an excel spreadsheet to count the occurrences
in two different columns and can't figure out the formula. For example, I want a total of cells that have a "yes" in column L and a "yes" in column O, if there is only a "yes" in one of the columns I don't want to count it. |
|
#2
|
|||
|
|||
|
=sumproduct(--(L1:L1000="Yes"),--(O1:O1000="Yes"))
"Shirley" wrote in message ... I am using an excel spreadsheet to count the occurrences in two different columns and can't figure out the formula. For example, I want a total of cells that have a "yes" in column L and a "yes" in column O, if there is only a "yes" in one of the columns I don't want to count it. |
|
#3
|
|||
|
|||
|
Hi
Try something like: =SUMPRODUCT((L2:L11="yes")*(O2:O11="yes")) When using SUMPRODUCT(), the ranges must contain the same number of cells, and you cannot use full column references. -- Andy. "Shirley" wrote in message ... I am using an excel spreadsheet to count the occurrences in two different columns and can't figure out the formula. For example, I want a total of cells that have a "yes" in column L and a "yes" in column O, if there is only a "yes" in one of the columns I don't want to count it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula in an Excel comment | Excel Discussion (Misc queries) | |||
| Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Linear Mode
