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
Medium Priority
273 Views
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
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
• 3
• 2

Author Comment

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

LVL 42

Accepted Solution

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

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

Expert Comment

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

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

Author Closing Comment

ID: 37804708
Awesome expert help always..
0

## Featured Post

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â€¦
###### Suggested Courses
Course of the Month5 days, 20 hours left to enroll