adding up columns in excel 2002

[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

 

[Guest]

In F50: =SUMIF(F4:F6,"day",E4:E6)

 

[Guest]

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)

---

 

[Guest]

Thanks Max I will give it a try

 

[Guest]

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

 

[Guest]

My trial resulted in an automatic formula update

Thanks Max I will give it a try