Excel Sum total amount if same data

-
Excel

Summarizr items if they have the same name, how many is the item(s), sum the total amount of the items.

Example

Service Amount
Item10 255
Item25 357
Item12 227
Item10 422.5
Item25 567
Item10 422.5
Item14 314.5
Item25 567
Item14 314.5
Item6 510
Item27 195.5
Item10 382.5
Item25 527
Item21 193
Item12 227

So here you have different items and prices

How to get them summed in excel?

ROW A is the items
ROW B is the prices
ROW C is the item name name (list all items if you have 100 items type it here)
ROW D is how many is that item
ROW E is how much is the total price of that specific item

ROW D CODE =SUMPRODUCT(--(A3:A5211=C3))

ROW E CODE =SUMIFS(B3:B5211,A3:A5211,C3)


Actual Excel Document with the computation here

Comments

Post a Comment

Popular posts from this blog

Water Wonder Resort

-
Image
Water Wonder Resort Location: Inarawan Antipolo City To go here from Cubao Gateway Side - Ride Jeep or Fx going to Padilla ask the driver you are going to Water Wonder Resort. From there you can take a tricycle. Best days to go here are not April or May since there are many people going here from Antipolo Area Earn money register free!
Read more

Redirect apache request to another domain

-
if you have example portal.tenerife.com portal.mazaredo.com portal.antolines.com and you want to redirect it to www.mazaredo.com in httpd.conf put this line RewriteEngine on RewriteCond %{HTTP_HOST} !^portal\.!^\.com$ [NC] RewriteRule ^(.*)$ http://www.mazaredo.com/$1 [R=301,L] As you can see the the url has 3 parts    portal, domain, com  !^portal\.!^\.com$ first part is !^portal\     you can also remove portal so any .com request going to your site will be redirected. second part is !^\ where it is like * anything. last part is .com$
Read more

Can't use proxy because no authentication schemes are fully configured.

-
So you are having problems on webmin + squid authentication ? My current setup is below. I was eating my finger nails asking why before it was working and now it doesnt. System hostname localhost.localdomain (127.0.0.1) Operating system CentOS Linux 6.3 Webmin version 1.620 Virtualmin version 3.98.gpl GPL Earn  money  register free! [root@122 ~]# service squid start Starting squid:                                            [FAILED] 2013/02/23 00:17:00| Processing Configuration File: /etc/squid/squid.conf (depth 0) 2013/02/23 00:17:00| ERROR: '0.0.0.0/0.0.0.0' needs to be replaced by the term 'all'. 2013/02/23 00:17:00| SECURITY NOTICE: Overriding config setting. Using 'all' instead. 2013/02/23 00:17:00| WARNING: (B) '::/0' is a subnetwork ...
Read more