| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif Multiple Criteria
I need to count the number of cells in Column A that contain an S, AND the
cells in Column B that contain an E. So, if there are a total of 6 rows, and 4 contain an S and 3 Contain an E the answer should be 3. Do I use COUNTIF OR SUMPRODUCT? What will the formula/function look like? |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(A2:A100="S"),--(B2:B100="E"))
so the answer is SP :-) -- HTH RP (remove nothere from the email address if mailing direct) "JoatNIC" wrote in message ... I need to count the number of cells in Column A that contain an S, AND the cells in Column B that contain an E. So, if there are a total of 6 rows, and 4 contain an S and 3 Contain an E the answer should be 3. Do I use COUNTIF OR SUMPRODUCT? What will the formula/function look like? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| Countif for multiple criteria | Excel Worksheet Functions | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
