Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-17-2006, 09:54 AM
LOGISTICS1 LOGISTICS1 is offline
Novice
SUMMING TWO COLUMNS
 
Join Date: Apr 2006
Location: Austin, TX
Posts: 1
LOGISTICS1
Default SUMMING TWO COLUMNS


Hello, I'm new to the site. I need help with a formula that looks up the item number and then sums up the total sales of that item number, from two different columns.

I appreciate any help I can get.

Thanks,

Mary
Reply With Quote
  #2  
Old 04-18-2006, 06:00 AM
adbarnes adbarnes is offline
Novice
 
Join Date: Jan 2006
Posts: 9
adbarnes
Default Try this

Here is a simple formula that may help.
Given the data here:
a b c
12345 1 1
6789 2 2
12345 1 1
6789 2 2
12345 1 1
6789 2 2
Item Result
12345 6
6789 12

To get the results. 12345:
=SUM(SUMIF(A1:A6,"12345",B1:B6)+SUMIF(A1:A6,"12345 ",C1:C6))

and
6789:
=SUM(SUMIF(A1:A6,"6789",B1:B6)+SUMIF(A1:A6,"6789", C1:C6))

HTH, Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i get my text in columns straight and inline in word 2007? terrasaw Word 0 09-03-2008 06:00 AM
Conditional Formatting to Hide Rows or Columns? sczegus Excel 0 09-26-2006 04:17 PM
SUMMING TWO COLUMNS Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft