| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Triple Criteria Formula
What formula counts how many cells contain three different criterias i.e. if a
cell D contains "Fr" and cell E contains "B" and cell F contains "Chancellors" I want it to count but not if it contains one of them or two of them. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Triple Criteria Formula
=sumproduct(--($D$1:$D$100="Fr"),--($E$1:$E$100="B"),--($F$1:$F$100="Chancellors"))
-- Regards, Tom Ogilvy "HonorsOA" wrote: What formula counts how many cells contain three different criterias i.e. if a cell D contains "Fr" and cell E contains "B" and cell F contains "Chancellors" I want it to count but not if it contains one of them or two of them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Triple lookup? | Excel Worksheet Functions | |||
| Apologies for triple post | New Users to Excel | |||
| crazy triple array formula | Excel Worksheet Functions | |||
| Triple occurence formula | Excel Worksheet Functions | |||
| Triple Lookup Formula! | Excel Programming | |||
Linear Mode
