Hi, first post
I've been trying to figure this out for awhile which lead me to these forums. Once I get the jist of how this works, it should help me with a great deal more.
I have a single workbook which contains several worksheets. I have a separate worksheet for formulas which create various totals based on the other worksheets. What I'm trying to do is create a formula like so
IF the date of cell in column D is equal to the year 2000 (the date format is day/month/year, and the day date is irrelvant in the formula) THEN give me the SUM of column F (but only where column F is in the same row as the column D that meets the required date).
I understand how to reference to another worksheet to create the formula just not the actually formula required to get the sum of a certain date.
Basically, I have a worksheet that records expenses over the past 8 years where each row is a purchase and includes data such as the date and amount etc.. so I want to create formulas on a separate worksheet that show the total expenditure for each year.
Any help appreciated. I will begin to crawl through these forums as they seem to contain a wealth of helpful stuff.
Bookmarks