Question re random addition

[Peter]

Hi,

I have a small spreadsheet, 7 columns wide. I coulmn 2 there are
various names which are repeated randomly, in colum 7 there are costs.

What I would like to do is somehow total all the costs for each name
in the spreadsheet - i.e if there are 12 names in all then have the
amount spent by each of the 12 people totalled individually.

Would someone be kind enough to point me towards a resource that may
help me achieve this?

I am using Excel 2003

--
Cheers

Peter

Please remove the invalid to reply

 

[merjet]

I have a small spreadsheet, 7 columns wide. I coulmn 2 there are

various names which are repeated randomly, in colum 7 there are costs.

What I would like to do is somehow total all the costs for each name
in the spreadsheet - i.e if there are 12 names in all then have the
amount spent by each of the 12 people totalled individually.

Use the worksheet function SUMIF. For the 1st argument use the
entire range of names (precede row numbers in range with $ to
facilitate copying). For the 2nd argument, use only the name in the
row. For the 3rd argument, use the entire range of costs (precede
row numbers in range with $ to facilitate copying).

Merjet

 

[Peter]

Hi,

I have a small spreadsheet, 7 columns wide. I coulmn 2 there are
various names which are repeated randomly, in colum 7 there are costs.

What I would like to do is somehow total all the costs for each name
in the spreadsheet - i.e if there are 12 names in all then have the
amount spent by each of the 12 people totalled individually.

Would someone be kind enough to point me towards a resource that may
help me achieve this?

I am using Excel 2003

Thanks both - SUMIF suits this spreadsheet very well - pivot tables
can await another day

--
Cheers

Peter

Please remove the invalid to reply

 

[Peter]

Unless this is a one time affair, too bad. Pivot Tables are one of the most
powerful features in Excel for summarizing numerical data found in a data
table.

Hi Tom,

Yes, this is a one off for this particular spreadsheet - (I needed to
work out a mobile phone bill)

I will need to carry out a similiar exercise on more sheets - I think
I shall need a pivot table then - I think they will take some getting
used to :-(
--
Cheers

Peter

Please remove the invalid to reply