| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells that match 2 criteria
I have serveral columns of Data. In Col B some rows contain "PC". Col F
contains a forumla that returns TRUE or FALSE. I want to count the number of times "PC" appears in col B but only when FALSE is in col F. I have used this type of formula many times but only when there is just text in col F ie =SUMPRODUCT((FINAL1!B2:BY5000="PC")*(FINAL1!F2:F50 00="Customer")) The formula in col F is =AND(B2="PC",D2="PC") I would be grateful for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| counting cells with two criteria | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Threaded Mode
