Microsoft Office Forums SUMMING TWO COLUMNS
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-17-2006, 09:54 AM
 LOGISTICS1 Novice Join Date: Apr 2006 Location: Austin, TX Posts: 1
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
#2
04-18-2006, 06:00 AM
 adbarnes Novice Join Date: Jan 2006 Posts: 9
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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post terrasaw Word 0 09-03-2008 06:00 AM sczegus Excel 0 09-26-2006 04:17 PM 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.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top