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 |