how to sumif when the range is split over several columns

[dgcaskey]

I have a sheet whose data looks like this (only much larger, of course):

Account# JanAmount Account# FebAmount Account# MarAmount
132441 $36.28 12444 $249.45 143144 $223.10
144314 $97.19 143144 $283.29 41343 $278.80
12444 $68.82
143144 $37.79
41343 $59.20

... and I need to summarize the data by account number in a table like this:

1st quarter totals
Account # Amount
132441 $36.28
144314 $97.19
12444 $318.27
143144 $544.18
41343 $338.00

Can I use sumif to summarize across several columns? Or is there a more elegant way to get my second table?

 

[Weazel]

maybe something like...

B9=SUMIF($A$2:$E$6,A9,$B$2:$F$6)

you need to pay close attention to the ranges

Row\Col	A​	B​	C​	D​	E​	F​
1​	Account#	JanAmount	Account#	FebAmount	Account#	MarAmount
2​	132441​	$36.28​	12444​	$249.45​	143144​	$223.10​
3​	144314​	$97.19​	143144​	$283.29​	41343​	$278.80​
4​	12444​	$68.82​
5​	143144​	$37.79​
6​	41343​	$59.20​
7​
8​	Account	Amount
9​	132441​	36.28​
10​	144314​	97.19​
11​	12444​	318.27​
12​	143144​	544.18​
13​	41343​	338​

<tbody>
</tbody>

 

[dgcaskey]

That worked great. Thank you!