Formula help needed

  • Thread starter Thread starter Hector
  • Start date Start date
H

Hector

Hi,
I am very new with excel. If I have several fields, each of which records
the number of a particular item - Say Field A (item 1), Field B (item 2),
Field C (item 3). When I create a report, I can see how to get the total of
items in each individual field. However, I cannot work out how to add
together the totals of Field A, Field B, and Field C to get a total of all
items. I imagine that this involves inserting a formula somewhere, but I
cannot work out how to do this. Can anyone help?
 
if you're very new with excel.. PLEASE i beg of you-- run away while
you still can

Excel is a disease.. go and learn a database instead
 
If say you put totals of Field A, B and C in say A100,B100 and C100
respectively, you can simply total those across with

=SUM(A1:C1)
 
Back
Top