adding up columns in excel 2002
 

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

adding up columns in excel 2002
 

In F50: =SUMIF(F4:F6,"day",E4:E6)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Techno Grandma" wrote:
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

adding up columns in excel 2002
 

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

adding up columns in excel 2002
 

Thanks Max I will give it a try

"Max" wrote:

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

adding up columns in excel 2002
 

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

"Techno Grandma" wrote:

Thanks Max I will give it a try

"Max" wrote:

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

adding up columns in excel 2002
 

My trial resulted in an automatic formula update

"Techno Grandma" wrote:

Thanks Max I will give it a try

"Max" wrote:

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---