software

I have five columns of data. Columns 1 and 2 are populated with names,
columns 3 through 5 with numbers. I would like to automatically create
subtotals in column in columns 3 through 5 for each combination of names that
appear on the same row in columns A and B.

Example:

Allen Barringer 4 16 30
Boldin Howard 6 8 4
Sievers Marks 7 10 54
Allen Marks 4 55 12
Howard Billens 44 5 66
Boldin Marks 33 55 1
Sievers Marks 5 12 40
Sievers Marks 0 22 33
Howard Billens 1 18 22

I would like to subtotal columns 3-5 each time Sievers and Marks appear on
the same row in columns A and B, respectively.

Thanks for your help,
Bob

How about putting another column in your data:

=a2amp;quot;,quot;b2quot;
and drag down.

Then sort by this column and apply Data|subtotals using that column as the key.

bob wrote:
gt;
gt; I have five columns of data. Columns 1 and 2 are populated with names,
gt; columns 3 through 5 with numbers. I would like to automatically create
gt; subtotals in column in columns 3 through 5 for each combination of names that
gt; appear on the same row in columns A and B.
gt;
gt; Example:
gt;
gt; Allen Barringer 4 16 30
gt; Boldin Howard 6 8 4
gt; Sievers Marks 7 10 54
gt; Allen Marks 4 55 12
gt; Howard Billens 44 5 66
gt; Boldin Marks 33 55 1
gt; Sievers Marks 5 12 40
gt; Sievers Marks 0 22 33
gt; Howard Billens 1 18 22
gt;
gt; I would like to subtotal columns 3-5 each time Sievers and Marks appear on
gt; the same row in columns A and B, respectively.
gt;
gt; Thanks for your help,
gt; Bob

--

Dave Peterson

Hi,

Try the following array formula (Ctrl shift Enter)

=sum(if((rangeA=quot;Sieversquot;)*(rangeB=quot;Marksquot;),rangeC ))

You may copy this range to column D and E now.

If you have any further questions, please feel free to contact me atRegards,

Ashish

quot;bobquot; wrote:

gt; I have five columns of data. Columns 1 and 2 are populated with names,
gt; columns 3 through 5 with numbers. I would like to automatically create
gt; subtotals in column in columns 3 through 5 for each combination of names that
gt; appear on the same row in columns A and B.
gt;
gt; Example:
gt;
gt; Allen Barringer 4 16 30
gt; Boldin Howard 6 8 4
gt; Sievers Marks 7 10 54
gt; Allen Marks 4 55 12
gt; Howard Billens 44 5 66
gt; Boldin Marks 33 55 1
gt; Sievers Marks 5 12 40
gt; Sievers Marks 0 22 33
gt; Howard Billens 1 18 22
gt;
gt; I would like to subtotal columns 3-5 each time Sievers and Marks appear on
gt; the same row in columns A and B, respectively.
gt;
gt; Thanks for your help,
gt; Bob