| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula using sumproduct
A--------------B-
6N FALSE 6N FALSE 7N TRUE 8N TRUE 6N TRUE I am using this as an array formula in C2 but getting zero for an answer when the correct answer would be 1. Can anyone tell me what I am doing wrong. I am looking for the formula to count the number of times "TRUE" is found in B2:B6 IF "6N" is also found in A2:A6. Any help would be greatly appreciated. SUMPRODUCT((A2:A6="6N")*(B2:B6="TRUE")) correct answer =1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| How best to use sumproduct instead of conditional sum: | Excel Worksheet Functions | |||
| How do I set up a conditional sumproduct formula (ie. sumifproduct | Excel Worksheet Functions | |||
| Conditional SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Conditional sumproduct? | New Users to Excel | |||
Threaded Mode
