Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
i have a column with over 2000 alpha character rows that i'm trying to count.
I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
try this
=SUMPRODUCT((C2:C2000={"h","m","y","u"})*1) -- Don Guillett Microsoft MVP Excel SalesAid Software "arch0072" wrote in message ... i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
Maybe
=COUNTIF(A:A,"*hmyu*") or for the string beginning with hmyu =COUNTIF(A:A,"hmyu*") Mike "arch0072" wrote: i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
Try this:
=COUNTIF(D:D,"*hmyu*") I've assumed your data is in column D. You can use wildcards with COUNTIF. Hope this helps. Pete On Sep 3, 1:44*pm, arch0072 wrote: i have a column with over 2000 alpha character rows that i'm trying to count. * I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. * I'm trying to count the total number of hmyu when listed in this column? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
Tested? -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike H" wrote in message ... Maybe =COUNTIF(A:A,"*hmyu*") or for the string beginning with hmyu =COUNTIF(A:A,"hmyu*") Mike "arch0072" wrote: i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
Yes, tested OK. I may have misunderstood the OP requirements but it does what
it was intended to do. i.e count the instances of hmyu either within or at the start of any string in any cell in A:A your issue being? Mike "Don Guillett" wrote: Tested? -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike H" wrote in message ... Maybe =COUNTIF(A:A,"*hmyu*") or for the string beginning with hmyu =COUNTIF(A:A,"hmyu*") Mike "arch0072" wrote: i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif or sumproduct?
If the OP is polite enough to respond then we will have our clarification
"Don Guillett" wrote: Depends on how you read this one of the following letters -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike H" wrote in message ... Yes, tested OK. I may have misunderstood the OP requirements but it does what it was intended to do. i.e count the instances of hmyu either within or at the start of any string in any cell in A:A your issue being? Mike "Don Guillett" wrote: Tested? -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike H" wrote in message ... Maybe =COUNTIF(A:A,"*hmyu*") or for the string beginning with hmyu =COUNTIF(A:A,"hmyu*") Mike "arch0072" wrote: i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the column. I'm trying to count the total number of hmyu when listed in this column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or SUMPRODUCT | Excel Worksheet Functions | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
Sumproduct or Countif | Excel Worksheet Functions | |||
SUMPRODUCT or COUNTIF? | Excel Worksheet Functions |