| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count how many different numbers in the column and return to the n
I have a sheet
Amount Item $12 1 $2 1 $8 3 $98 2 $23 2 the thing I would like to do is item amount 1 total(amount part is easy, I can use sumif()) 2 *** 3 *** the item part is hard, I tried if(countif()0,item #), but I have 7 items in total, if I have only 3 items in the colume, I will have 4 empty rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to return a set of numbers in column A | Excel Worksheet Functions | |||
| how to return a set of numbers in column A | Excel Worksheet Functions | |||
| count and return pair numbers | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
