| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
