Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm using a sheet that has Octal values in it, so only 0 tru 7 are used as numbers. A value in column F in entered in Octals e.g. 00200, another value is entered in column G e.g. 00377. Now I would like the total amount of numbers to show up in Column H, so in this case 128. There are a couple of snacks, the following numbers cannot be used and therefore should not be counted in the total amount; 77 and 176 and 177 and 77777 (77777 is also the last number in the sequence. Can anybode help? Paul. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting If | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting Rows Then Counting Values in Columns | Excel Programming | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |