Use Sumif on first row criteria

[pto160]

I want to use the sumif on the first row of the criteria and leave the second row blank as I am copying it down. I do not want to have do it manually. I have Excel 2007.

Sheet1

<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td>A</td> <td style="TEXT-ALIGN: right">10</td> <td style="TEXT-ALIGN: right">30</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td>A</td> <td style="TEXT-ALIGN: right">20</td> <td> </td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td>B</td> <td style="TEXT-ALIGN: right">15</td> <td style="TEXT-ALIGN: right">35</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td>B</td> <td style="TEXT-ALIGN: right">20</td> <td> </td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>C1</td> <td>=SUMIF($A$1:$A$4,A1,$B$1:$B$4)</td></tr> <tr> <td>C3</td> <td>=SUMIF($A$1:$A$4,A3,$B$1:$B$4)</td></tr></tbody></table></td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Marcelo Branco]

Maybe this

C1
=IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

copy down

M.

 

[pto160]

Yes, that works great. Saved me a lot of time trying to delete rows and then adding in the total. Thanks for your help.

 

[Marcelo Branco]

Yes, that works great. Saved me a lot of time trying to delete rows and then adding in the total. Thanks for your help.

You are welcome!

M.