Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

Sum if same type Excel

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
Rayne
Asked:
Rayne
  • 3
  • 2
2 Solutions
 
RayneAuthor Commented:
Basically a formula that will run down the entire column and do the needful...
0
 
dlmilleCommented:
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
 
dlmilleCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
slobber72Commented:
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
 
RayneAuthor Commented:
Awesome Dave, thank you so much. That explains it totally :)
0
 
RayneAuthor Commented:
Awesome expert help always..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now