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

Black screen after logging in on Windows 2012 R2 using domain credentials on remote desktop connection

-
https://support.microsoft.com/en-us/kb/970879 Blank Desktop on Windows Vista or Windows Server 2008  Email  Print Source:  Microsoft Support RAPID PUBLISHING RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION. Symptom After logging on to a Windows Vista or Windows Server 2008 computer, you are presented with a blank screen with no Start Menu, shortcuts, or icons. If you reboot and use F8 to boot to Safe Mode with Networking, you will see your normal desktop.  You may see the following events in the Application log:  Log Name: Application  Source: Microsoft-Windows-Winlogon  Event ID: 4006  Level: Warning  User: N/A  Computer: M1.Contoso.com  Description:  The Windows logon process has failed to spawn a user application. Application name: . Command line parameters:
Read more

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

Client denied by server configuration error

-
Client denied by server configuration error in Apache. Wed, 01/23/2008 - 00:33 — artur Just in case if somebody else has a similar problem and can't get the Apache server working as expected. I have tried to setup proxy_mod under apache to forward HTTP traffic from AJAX Jabber client to the Bosh component running on Tigase server. It was working fine for a long time on my Gentoo server. I have recently wanted to run more tests on a separate machine and had this problem. It was a system based on the Debian distribution and the proxy_mod didn't want to work at all displaying the error message in a log file: [error] [client ::1] client denied by server configuration: proxy:http://127.0.0.1:5280/xmpp/ , referer: http://localhost/F5A379CEC35AEBCC5FFA11BA8A33CD02.cache.html All you need to do is to modify proxy.conf file for your Apache2 installation and setup proper permissions. By default the proxy is disabled for all. In my case I had to enable it just f
Read more