## Excel filter: How do I add only data for a given month?

I have an Excel worksheet that logs hikes. The columns are date, location, miles, notes. The rows are hikes. I have a summary worksheet in the same workbook that I use to track progression. Things like cumulative miles for the year, average miles per month. I'd like to add month by month totals. I want to write a formula that will sum the distance only for a particular month (for example, January). I need a formula that will test if the hike occurred in that month, then add the miles to the sum. What would this formula look like?
posted by OrangeDisk on Jan 21, 2016 - 5 answers

## Excelfilter: Get max from selection of items based on another column?

I have an Excel question. I have a list of items, some of which are duplicates. Each item has a figure attached. I'd like to find the maximum value for each duplicate item and put that in another cell.
posted by synecdoche on Jul 26, 2015 - 5 answers

## IF/THEN Excel Question: IF A1=any text THEN D1=1, if blank nothing

I am trying to create a list that then calculates the quantity of people on the list. I want a formula that will check A1 and B1 and see if they are blank, if so, I want nothing, if they have anything in them, I want them to be added together. I don't know exactly how to do this formula.
posted by MnMrMstrd7 on Jun 2, 2015 - 7 answers

## Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
posted by FireStyle on Feb 23, 2013 - 9 answers

## How do I create an amortization table where my payments change every period?

Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique?
posted by lea724 on Mar 29, 2012 - 16 answers

## Help with Excel formula and table

I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met.
posted by desjardins on Feb 21, 2012 - 8 answers

## stymied by excel

There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data. asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle on Mar 17, 2011 - 6 answers

Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet?
posted by DrtyBlvd on Jan 28, 2011 - 7 answers

## Getting Excel to reconcile two types of data

Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily?
posted by Muffy on Feb 12, 2010 - 8 answers

## Need help making an excel formula

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries.
posted by FireStyle on Dec 2, 2009 - 4 answers

## Conditional Formula Selection in Excel

How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas?

## Need excel formula to calculate the number of days in a date range, if they end within that range

I need a formula to help calculate the number of days as compared to a range. Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range.
posted by malcommc on Oct 1, 2009 - 9 answers

## Everything looks like a nail!

Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's...

## Excel formulas for Dummies, please.

This is probably a pretty basic Excel formula question, but I'm clueless.
posted by zardoz on May 27, 2009 - 3 answers

## Intense Excel Question: Calculate a rolling YTD/YTD that is dynamic?

Intense Excel Question: Calculate a rolling YTD/YTD that is dynamic?
posted by Carialle on Sep 11, 2008 - 10 answers

Complicated Excel formula question involving text-search and Japanese characters. Can you help?
posted by Vorteks on May 27, 2008 - 2 answers

## complex dice probability make head esplode

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below.
posted by DetonatedManiac on Dec 21, 2007 - 7 answers

## excelfilter

I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe.
posted by thecjm on May 21, 2006 - 7 answers

Page: 1