Excel 2007 - Conditional results added together in a totals cell

  • Thread starter Thread starter Dan Trotter
  • Start date Start date
D

Dan Trotter

Hi to all, I'm truly a beginner with pushing excel a bit, but what I'm trying to achieve seems logical and simple enough in my mind.

I've got a simple daily sales sheet that is edited at each salepoint. I've got a drop-down list of vendors in Column A sorted in a Data Validation list so that much is straight forward, another few columns of details and {price totals} at the end, such as:

Company X | Details | QTY | PriceEa | PriceTotal |

I'm trying to automate a result that if the Company equals {Company1} then the total in that rows {pricetotal} gets added to a particular cell corresponding to that company only, which is in a summary matrix. Hopefully I've explained myself clearly enough?

EggHeadCafe - Software Developer Portal of Choice
Searching Active Directory For Users and Groups
http://www.eggheadcafe.com/tutorial...8-d7a24fe7e0e1/searching-active-director.aspx
 
Suppose you list your vendors in column G, starting with G2. Then in
H2 you could have this formula:

=SUMIF(A:A,G2,E:E)

Then copy this down for as many vendors as you have in your list.

Hope this helps.

Pete
 
Back
Top