| 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 |
| 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 | |||
Threaded Mode
