Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of text values in a specific row
Hello I have a data sheet that looks likes this:
Reading Date Site 1 Site 2 Site 3 Site 4 ..... Jun 1,2007 XP XP D XP Jun 2, 2007 XP D D P Question: I want use a function that will enable the user to enter a date, and the function will search for that date, and count the number of times the code XP, is entered. Can anyone help me out with my quest? -- Carlee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of text values in a specific row
Count the number of "XP" in that row where the date is? Okay, assume that the
dates are in column A, and the site columns are B, C, D, E... I would use this: =COUNTIF(INDEX($A$100:$E$100, MATCH(date, $A:$A, 0), 1):INDEX($A$100:$E$100, MATCH(date, $A:$A, 0), 5), "=XP") Replace "$A$100:$E$100" with the range that contains your data... and replace "5" in the MATCH function to the number of columns in your data range. "date" is the reference that contains the date you want to look up. Hope that helps. "Carlee" wrote: Hello I have a data sheet that looks likes this: Reading Date Site 1 Site 2 Site 3 Site 4 ..... Jun 1,2007 XP XP D XP Jun 2, 2007 XP D D P Question: I want use a function that will enable the user to enter a date, and the function will search for that date, and count the number of times the code XP, is entered. Can anyone help me out with my quest? -- Carlee |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of text values in a specific row
Try this:
H1 = some date =COUNTIF(INDEX(A1:E3,MATCH(H1,A1:A3,0),),"xp") Biff "Carlee" wrote in message ... Hello I have a data sheet that looks likes this: Reading Date Site 1 Site 2 Site 3 Site 4 ..... Jun 1,2007 XP XP D XP Jun 2, 2007 XP D D P Question: I want use a function that will enable the user to enter a date, and the function will search for that date, and count the number of times the code XP, is entered. Can anyone help me out with my quest? -- Carlee |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of text values in a specific row
Assume date in A5:A100, Site 1,2,3,4.... in B5:Z100
A1: is the user to enter date B1: =SUMPRODUCT((A5:A100=A1)*(B5:Z100="XP")) "Carlee" wrote: Hello I have a data sheet that looks likes this: Reading Date Site 1 Site 2 Site 3 Site 4 ..... Jun 1,2007 XP XP D XP Jun 2, 2007 XP D D P Question: I want use a function that will enable the user to enter a date, and the function will search for that date, and count the number of times the code XP, is entered. Can anyone help me out with my quest? -- Carlee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif for the number of a specific count? | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Count the number of specific values in a cell | Excel Worksheet Functions | |||
Trying to count specific values | Excel Worksheet Functions | |||
How do I count my data that are between specific values? | Excel Worksheet Functions |