| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Multiple Instances
I need to count the number of times F shows in column C at the same time Y
appears in column n Thanks ce |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Multiple Instances
Try something like this:
=SUMPRODUCT((C1:C20="F")*(N1:N20="Y")) Does that help? *********** Regards, Ron XL2002, WinXP "Curtis" wrote: I need to count the number of times F shows in column C at the same time Y appears in column n Thanks ce |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Multiple Instances
=SUMPRODUCT((C1:C5000="F")*(N1:N1000="Y"))
you cannot use full column references (C:C) with SUMPRODUCT, so adjust the ranges as needed best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Curtis" wrote in message ... I need to count the number of times F shows in column C at the same time Y appears in column n Thanks ce |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Multiple Instances
Opps =SUMPRODUCT((C1:C5000="F")*(N1:N5000="Y"))
must have equal sized arrays -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bernard Liengme" wrote in message ... =SUMPRODUCT((C1:C5000="F")*(N1:N1000="Y")) you cannot use full column references (C:C) with SUMPRODUCT, so adjust the ranges as needed best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Curtis" wrote in message ... I need to count the number of times F shows in column C at the same time Y appears in column n Thanks ce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Multiple instances of Single Criterion in Row & Return To a Single Col | Excel Worksheet Functions | |||
| Multiple instances across monitors? | Excel Discussion (Misc queries) | |||
| Why are there multiple instances of same person on shared workshee | Excel Discussion (Misc queries) | |||
| Counting multiple occurances of a specific string | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Hybrid Mode
