Solved

Sum if same type Excel

Posted on 2012-04-03
6
258 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
  • 3
  • 2
6 Comments
 

Author Comment

by:Rayne
Comment Utility
Basically a formula that will run down the entire column and do the needful...
0
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
Comment Utility
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 41

Assisted Solution

by:dlmille
dlmille earned 500 total points
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Expert Comment

by:slobber72
Comment Utility
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
Comment Utility
Awesome Dave, thank you so much. That explains it totally :)
0
 

Author Closing Comment

by:Rayne
Comment Utility
Awesome expert help always..
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now