| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif, countif, sumproduct?????
Hello,
I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes, yes, Yes. I want to count on col D if it says yes and the coresonding cell in Col C says yes. Thus I would like a formula to return a count of 3 for this example. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| sumproduct vs. countif | Excel Discussion (Misc queries) | |||
| Sumproduct, If, Sumif, Countif, Match?? | Excel Discussion (Misc queries) | |||
| countif, sumif, sumproduct - I dont know which to use | Excel Worksheet Functions | |||
| Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
