|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 20th, 2009, 04:16 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Count if
I trying to count enties with different conditions
example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF 
|
|
#2
July 20th, 2009, 04:33 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
You might want to take a look at the OR/AND functions (XL help file). For
what you have so far: =IF(OR(A1=A2,A2A3),1,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ecf123" wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
|
#3
July 20th, 2009, 04:36 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
ecf123;423499 Wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECFyou want to count entries where? in what range? where would you like the formula to go? 2 ways of doing it in B1 (or wherever) =IF(A1=A2,1,IF(A1A2,0,IF(A2A3,1,0))) or =IF(OR(A1=A2,A2A3),1,0) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117750
|
|
#4
July 20th, 2009, 04:39 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
Hi,
if(OR(a1=a2,a2a3),1,0) "ecf123" wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
|
#5
July 20th, 2009, 04:55 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
=--OR(A1=A2,A2A3)
-- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "ecf123" wrote in message ... I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
|
#6
July 20th, 2009, 09:10 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
Hi,
Let me be a stickler - if A2=A3 what happens? As asked you might write =--AND(A1=A2,A2A3) or -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ecf123" wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
|
#7
July 24th, 2009, 08:33 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
Hi,
I am trying to count the cells in a column ending with a particular letter. Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is giving zero as the answer instead of 2. Please help.. "Luke M" wrote: You might want to take a look at the OR/AND functions (XL help file). For what you have so far: =IF(OR(A1=A2,A2A3),1,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ecf123" wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
|
#8
July 24th, 2009, 05:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count if
You probably have invisible characters *after* the final "P".
Maybe Space or the non-breaking, often used web space, Char(160). Do a character count of one of the cells in question, =Len(a1) and compare the number to what you can see. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "David" wrote in message ... Hi, I am trying to count the cells in a column ending with a particular letter. Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is giving zero as the answer instead of 2. Please help.. "Luke M" wrote: You might want to take a look at the OR/AND functions (XL help file). For what you have so far: =IF(OR(A1=A2,A2A3),1,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ecf123" wrote: I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
