Sumif Problem

[PatMorris]

Hello,

I am trying to create a ifsum formula where there is a unique value on two separate sheets (sheet1 & Sheet2). I am looking to sum an additional column that has dollar values connected to the unique value. Please note the possibly for duplicates of the unique value could occur </SPAN>

 

[Robert Mika]

Hello,

I am trying to create a ifsum formula where there is a unique value on two separate sheets (sheet1 & Sheet2). I am looking to sum an additional column that has dollar values connected to the unique value. Please note the possibly for duplicates of the unique value could occur

Hello and welcome to mr Excel.
Coudl you provide a sample of your data?

 

[PatMorris]

In Sheet1 cell G6:G197 has a unique identifier and sheet2 cell K2:K1142 has the same </SPAN>unique identifier, and then I am trying to same the dollar values connected to the unique identifier in Cell E of sheet2

 

[Robert Mika]

In Sheet1 cell G6:G197 has a unique identifier and sheet2 cell K2:K1142 has the same unique identifier, and then I am trying to same the dollar values connected to the unique identifier in Cell E of sheet2

Sorry i'm still confused moreover your ranges have different lenght.

Provide some data-see below on how to.

 

[PatMorris]

Sorry i'm still confused moreover your ranges have different lenght.

Provide some data-see below on how to.

The length of the data range in sheet2 is larger due to the fact that it contents additional information unrelated to the information in sheet1.

 

[Vidar]

Something like this?
=SUMIF(Sheet2!$K$2:$K$1142,Sheet1!G6,Sheet2!$E$2:$E$1142)

Vidar

 

[PatMorris]

Something like this?
=SUMIF(Sheet2!$K$2:$K$1142,Sheet1!G6,Sheet2!$E$2:$E$1142)

Vidar

That formula worked... How would I use a similar formula to sum the totals by month... Sheet2 has the months in cell A2:a1142.

 

[Sam_D_Ben]

<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>


<table class="tableizer-table">
<tr class="tableizer-firstrow"><th></th><th>B</th><th>C</th><th> </th><th> </th><th>F</th><th>G</th></tr> <tr><td>1</td><td>Jan</td><td>230</td><td> </td><td>1</td><td>$100.00</td><td>Jan</td></tr> <tr><td>2</td><td>Feb</td><td>115</td><td> </td><td>2</td><td>$115.00</td><td>Feb</td></tr> <tr><td>3</td><td>Mar</td><td>0</td><td> </td><td>3</td><td>$130.00</td><td>Jan</td></tr> <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td> </td><td>Sheet1</td><td> </td><td> </td><td> </td><td>Sheet2</td><td></td></tr></table>

Excel 2007
	A	B	C	D	E	F	G
1		Month	Total			Amount	Month
2	1	Jan	230		1	$100.00	Jan
3	2	Feb	115		2	$115.00	Feb
4	3	Mar	0		3	$130.00	Jan
5
6		Sheet1				Sheet2
Sheet1

Cell Formulas
Range	Formula
C2	=SUMIF($G$2:$G$4,$B$2:$B$4,$F$2:$F$4)
C3	=SUMIF($G$2:$G$4,$B$2:$B$4,$F$2:$F$4)
C4	=SUMIF($G$2:$G$4,$B$2:$B$4,$F$2:$F$4)
E3	=+E2+1
E4	=+E3+1

Hope this helps ..Dont copy it as such..alter it according to yours..Cheers Muz

 

[PatMorris]

That's for the help... I need to sum each month for each CUSIP ID in my work book

 

[Robert Mika]

That's for the help... I need to sum each month for each CUSIP ID in my work book

Still part of your data wil be useful.
In which Sheet does your CUSIP ID column is?
Whic Excel version are you using?