| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counts repeated number in two different area only once
I have a formula that count repeat number only once, but in the same area only:
IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9)0,1, 0) I want to count all the repeats to A1 in both area only once. thanks EggHeadCafe - Software Developer Portal of Choice MDI Inter-Form Communication with Events http://www.eggheadcafe.com/tutorials...ommunicat.aspx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counts repeated number in two different area only once
That compound function doesn't work. Maybe this is what you want:
=IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9,A1) 0,1,0) Or, this: =IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9,A1) 1,1,0) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sierra spiegel" wrote: I have a formula that count repeat number only once, but in the same area only: IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9)0,1, 0) I want to count all the repeats to A1 in both area only once. thanks EggHeadCafe - Software Developer Portal of Choice MDI Inter-Form Communication with Events http://www.eggheadcafe.com/tutorials...ommunicat.aspx . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counts repeated number in two different areas only once
Thank you very much, Ryan. Your formula works perfectly.
ryguy7272 wrote: That compound function does not work. 02-Nov-09 That compound function does not work. Maybe this is what you want: =IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9,A1) 0,1,0) Or, this: =IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9,A1) 1,1,0) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sierra spiegel" wrote: Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice ASP.NET Membership and Roles in Silverlight 3 http://www.eggheadcafe.com/tutorials...ip-and-ro.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counts repeated number in two seperate area | Excel Worksheet Functions | |||
| average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
| Number of Months Counts | Excel Worksheet Functions | |||
| Number counts within Date Range | Excel Worksheet Functions | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
Linear Mode
