| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the items
COUNTIF(A1:A3,"apple")
SUMIF(A1:A3,"apple",B1:B3) "Tyrone Lopez" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the items
Hi!
This table being in the range A1:B4. A1 and B1 are headers. Data in A2:B4. Item $ apple 1.00 apple 2.00 orange 1.50 ...........D............E..............F 1......Item......Count.........Sum 2......Apple............................ 3.....Orange........................... Enter this formula in E2: =COUNTIF(A$2:A$4,D2) Enter this formula in F2: =SUMIF(A$2:A$4,D2,B$2:B$4) Select both E2 and F2 then copy down as needed. Biff "Tyrone Lopez" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the items
This is just made for pivot tables,
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Tyrone Lopez" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the items
Hi guys, Thanks a million, you've made my day. I was using the formulas but did not know what to do until your replies. -- 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 |
| Reply |
| 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) | |||
Linear Mode
