| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF / AND functions
Try a formula like
=SUMPRODUCT(--(A1:A5=1),--(B1:B5=1),--(C1:C5=3)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dlund" wrote in message ... what if you have 3 columns to check? with an array like 1 1 3 2 1 2 2 1 4 1 2 3 1 1 3 How do you count the number of "1 1 3" occurances? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf Functions | Excel Worksheet Functions | |||
| Countif & AND functions | Excel Worksheet Functions | |||
| COUNTIF & AND Functions | Excel Worksheet Functions | |||
| COUNTIF & AND FUNCTIONS | Excel Discussion (Misc queries) | |||
| Using COUNTIF and AND functions together | Excel Worksheet Functions | |||
Threaded Mode
