Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
I have d2, e2 and f2 with text in them. The text is either 'Physical' or
'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
Hi,
=COUNTIF(D2,"Physical)+COUNTIF(F2,""Physical") Hope this helps, Gav. "q3pd" wrote: I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
Please re-state your requirement. Your formula of =Countif(d2:f2,
"Physical") , in fact does not work to meet your statement of " When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2." Vaya con Dios, Chuck, CABGx3 "q3pd" wrote: I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
Thank you..........Ok then to that criteria, Gav's formula should do it for
you.......... Vaya con Dios, Chuck, CABGx3 "q3pd" wrote: I want a function that when it sees the text 'Physical' in cell d2 and/or in f2 it returns the numerical value of 1 (or 2 depending on how many it sees) in cell a1 (where the function will go). If it sees any other text in d2 and/or f2 it returns 0 if 'Physical' is not in either. -- Q3PD "CLR" wrote: Please re-state your requirement. Your formula of =Countif(d2:f2, "Physical") , in fact does not work to meet your statement of " When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2." Vaya con Dios, Chuck, CABGx3 "q3pd" wrote: I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
I want a function that when it sees the text 'Physical' in cell d2 and/or in
f2 it returns the numerical value of 1 (or 2 depending on how many it sees) in cell a1 (where the function will go). If it sees any other text in d2 and/or f2 it returns 0 if 'Physical' is not in either. -- Q3PD "CLR" wrote: Please re-state your requirement. Your formula of =Countif(d2:f2, "Physical") , in fact does not work to meet your statement of " When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2." Vaya con Dios, Chuck, CABGx3 "q3pd" wrote: I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif text in individual cells
=(D2="Physical")+(F2="Physical")
-- David Biddulph "q3pd" wrote in message ... I want a function that when it sees the text 'Physical' in cell d2 and/or in f2 it returns the numerical value of 1 (or 2 depending on how many it sees) in cell a1 (where the function will go). If it sees any other text in d2 and/or f2 it returns 0 if 'Physical' is not in either. -- Q3PD "CLR" wrote: Please re-state your requirement. Your formula of =Countif(d2:f2, "Physical") , in fact does not work to meet your statement of " When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2." Vaya con Dios, Chuck, CABGx3 "q3pd" wrote: I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in a1 that returns the number of cells with 'Physical', not including cell e2. E.g.: Countif(d2:f2, "Physical") returns 3 if all three cells have Physical in them, however i want it to return 2 and ignore cell e2.. I tried Countif(d2,f2 "Physical"), however Excel will not accept this. How do I do this function? -- Q3PD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert URL Text to Individual URL Shortcut | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Coverting string of text into individual sums? | Excel Discussion (Misc queries) | |||
Help importing text files into individual cells | Excel Discussion (Misc queries) |