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.
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.
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
>
>
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks