adding up columns in excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table and I have a numeric and text column that I wish to total in a
cell within the table. In other words if columns f4, f5, f7 have the word
day and if e4, e5, e7 have values like 1.2, 1.1, 1.2 then I want to have 3.5
to show in say f50. How can I make this happen? Thanks
 
Working like a charm. Question now on what happens if you add rows in the
table, will the formula automaically pick up the cell range change or would a
person have to make that correction
 
Back
Top