Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sum if same type Excel

Posted on 2012-04-03
6
Medium Priority
?
273 Views
Last Modified: 2012-04-03
Hello,

I need help regarding this sumif issue. How can I sum up the total dollar used same events
Thank you

R
SumIfSameColumnValue.xlsx
0
Comment
Question by:Rayne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 

Author Comment

by:Rayne
ID: 37804106
Basically a formula that will run down the entire column and do the needful...
0
 
LVL 42

Accepted Solution

by:
dlmille earned 2000 total points
ID: 37804218
Put this in cell F10 and copy down:

[F10]=IF($C10<>$C11,SUMIF($C$10:$C$16,$C10,$E$10:$E$16),"")

See attached,

Dave
SumIfSameColumnValue.xlsx
0
 
LVL 42

Assisted Solution

by:dlmille
dlmille earned 2000 total points
ID: 37804221
PS - you can also use the Data-Subtotal feature by selecting the range, select the DATA ribbon, then Subtotal.  The defaults from there would sum up based on the first column (re: occassion).

Its hard to "undo" once you've done it, but it gives you the subtotals, and the ability to group down to just the subtotals and see the grand total.

Here's a tutorial on the subject:
http://office.microsoft.com/en-us/excel-help/insert-subtotals-in-a-list-of-data-in-a-worksheet-HP010079192.aspx

See attached output from that approach.

Dave
SumIfSameColumnValue-r1.xlsx
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Expert Comment

by:slobber72
ID: 37804467
I would also check the use of pivot tables. Excel 2010 (not sure about 2007) have this feature called "slicers" that come in very handy also.
0
 

Author Comment

by:Rayne
ID: 37804702
Awesome Dave, thank you so much. That explains it totally :)
0
 

Author Closing Comment

by:Rayne
ID: 37804708
Awesome expert help always..
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question