Excel

[Guest]

Need some help please.............

Senario.......

in Column B you have a company names (different ones), then is say coulmn E
you have some figures like say number of kgs.

Is it possible to add all the figures from column E for each different
company...

Column B Colum E
Smiths 123kgs
Jones 200kgs
fred 75kgs
Smiths 450kgs

so you get say a months total of the kgs each company has done.

 

[Guest]

Use "SUMIF"

This is for Access, not Excel.

 

[Guest]

Or you can use a pivot table of course

 

[Joseph Meehan]

Microsoft's Help system has landed you in the wrong newsgroup: this
one is for the database program Microsoft Access.

Please use the dropdown box (the one that says "Access" by default)
to select a more appropriate newsgroup, or search on
http://www.google.com.