| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Some options...
[1] =SUMPRODUCT(($A$2:$A$100=1)+0,($B$2:$B$100=2)+0) [2] =SUM(IF($A$2:$A$100=1,IF($B$2:$B$100=2,1))) followed by control+shift+enter. [3] C2, copied down: =A2&"#"&B2 =COUNTIF($C$2:$C4100,"="&1&"#"&2) [4] Construct a pivot table. brendalw wrote: is there a form of countif that increments only if conditions are met in two (or more) columns? e.g., countif(colA = 1 and colB = 2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Alpha & Numeric Counts in Excel | Excel Discussion (Misc queries) | |||
| How do I sum a range after 2 different conditions are met (2 colu. | Excel Discussion (Misc queries) | |||
Threaded Mode
