| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting the items
Is there a formula to count the number of items in a list and its corresponding sum value, eg Item $ apple 1.00 apple 2.00 orange 1.50 For the above, the result should be apple=2 items, totalling $3.00. Orange+ ! item totalling $1.50. :) -- Tyrone Lopez ------------------------------------------------------------------------ Tyrone Lopez's Profile: http://www.excelforum.com/member.php...o&userid=22194 View this thread: http://www.excelforum.com/showthread...hreadid=544540 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting different items in one column | Excel Discussion (Misc queries) | |||
| Counting number of items being added in a formula | Excel Discussion (Misc queries) | |||
| counting unique items | Excel Discussion (Misc queries) | |||
| counting filtered items | Excel Worksheet Functions | |||
| counting similar items in a column | Excel Discussion (Misc queries) | |||
Threaded Mode
