Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
I'm wanted to build a formula that will do the following,
CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
Try the below which will get you the count of postcodes starting with EH
=COUNTIF(A:A,"EH*") If this post helps click Yes --------------- Jacob Skaria "Onyx" wrote: I'm wanted to build a formula that will do the following, CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
Thank you, but i want the could to look up a list of post codes
"Jacob Skaria" wrote: Try the below which will get you the count of postcodes starting with EH =COUNTIF(A:A,"EH*") If this post helps click Yes --------------- Jacob Skaria "Onyx" wrote: I'm wanted to build a formula that will do the following, CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
With you list in C1:C10 the below will count the entries in A:a100 for which
the first two characters are in the list =SUMPRODUCT(--(ISNUMBER(MATCH(LEFT(A1:A100,2),C1:C10,0)))) If this post helps click Yes --------------- Jacob Skaria "Onyx" wrote: Thank you, but i want the could to look up a list of post codes "Jacob Skaria" wrote: Try the below which will get you the count of postcodes starting with EH =COUNTIF(A:A,"EH*") If this post helps click Yes --------------- Jacob Skaria "Onyx" wrote: I'm wanted to build a formula that will do the following, CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
On Mon, 8 Jun 2009 03:26:01 -0700, Onyx wrote:
I'm wanted to build a formula that will do the following, CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total If there are no blanks, you could use this formula: =SUMPRODUCT(COUNTIF(PostCodes,PostCodeList&"*")) where PostCodes is the range where you have your column of postcodes, and PostCodeList is the list of specific codes you wish to count. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data left | Excel Discussion (Misc queries) | |||
Using LEFT() in COUNTIF | Excel Discussion (Misc queries) | |||
COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A") | Excel Worksheet Functions | |||
data entry right to left | Excel Discussion (Misc queries) | |||
Sort data from Left to Right | Excel Discussion (Misc queries) |