I wansn't sure what to name this thread as I am not sure how to solve the problem. Here is what my spreadsheet looks like:
Column: C E
1-2-00 $16.50
2-4-01 $11.25
6-10-02 $10.00
etc.
I have several rows of data and I need the formula add the dollar amount in column E for a specific year.
EX- if I add all of year 2000 then the result would be $16.50, and so on.
Any ideas??
Your help would be greatly apprieciated!
Seth
Column: C E
1-2-00 $16.50
2-4-01 $11.25
6-10-02 $10.00
etc.
I have several rows of data and I need the formula add the dollar amount in column E for a specific year.
EX- if I add all of year 2000 then the result would be $16.50, and so on.
Any ideas??
Your help would be greatly apprieciated!
Seth