I'm trying to figure out a way to Sum charges based upon date criteria and charge type criteria. Here's my problem. I keep a spreadsheet for personal finances. I use codes for different charges to easily sum and keep track of categories. Here's what it would look like: Date ...

I am using Excel 2007. I have created a spreadsheet1 with a list of names and dates. The names and dates can be repeated. I have another spreadsheet 2 with names and formulas. Here the names are not repeated. The formulas adjust the dates for aging purposes. If the name on Spreadsheet 1 equals...

I am trying to run the IF function in excel against text rather numerical values. However it does not seem to want to process the argument. Is there a way to get this to work? Cheers

I am looking for a formula that allows me to have a specific text if the value in the cell selected is between 19xx and 19yy. I thought of using IF but can't figure it out... :( If the value is greater than 1967 and less than 1977 value = 30s

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...