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


[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Account#[/TD]
[TD]JanAmount[/TD]
[TD]Account#[/TD]
[TD]FebAmount[/TD]
[TD]Account#[/TD]
[TD]MarAmount[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

132441​

[/TD]
[TD]

$36.28​

[/TD]
[TD]

12444​

[/TD]
[TD]

$249.45​

[/TD]
[TD]

143144​

[/TD]
[TD]

$223.10​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

144314​

[/TD]
[TD]

$97.19​

[/TD]
[TD]

143144​

[/TD]
[TD]

$283.29​

[/TD]
[TD]

41343​

[/TD]
[TD]

$278.80​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

12444​

[/TD]
[TD]

$68.82​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

143144​

[/TD]
[TD]

$37.79​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

41343​

[/TD]
[TD]

$59.20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]Account[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

132441​

[/TD]
[TD]

36.28​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

144314​

[/TD]
[TD]

97.19​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]

12444​

[/TD]
[TD]

318.27​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]

143144​

[/TD]
[TD]

544.18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]

41343​

[/TD]
[TD]

338​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[dgcaskey]

That worked great. Thank you!