## Mileage in Excel (or in something else)

There has to be a way that I can track my mileage in Excel.
posted by aetg on Oct 6, 2015 - 5 answers

## Why is SUMIF function not working when data is formatted as a table?

I am developing a sales lead sheet. I have on the B column a drop down list for the sales status (complete, no sale, and follow up). On the A column I have a dollar amount for the sales lead. Originally, I used the SUMIF function to add only the "follow up" figures referenced from Column B to track the dollar amount of outstanding leads. I then thought to convert my sheet into a table to make sorting easier, but now the SUMIF function is returning a value of zero. What did I miss? Thanks much!
posted by FireStyle on Dec 7, 2013 - 2 answers

## And maybe something with dollar signs I don't know

Need help with (possibly?) "indirect" in Excel.
posted by phunniemee on May 16, 2012 - 21 answers

## Excel Quest

I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row?
posted by amethysts on Mar 23, 2010 - 7 answers

## Calling all pairs

Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result?
posted by albrecht on Mar 9, 2010 - 11 answers

## Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set?
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

## Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel.
posted by FatherDagon on Aug 5, 2009 - 5 answers

## Vlookup help for comparing lists of numbers

I am trying to partially automate a tedious list comparison procedure, I think I should be able to do it through excel without any coding (which I don't know how to do)
posted by dripped on Mar 19, 2009 - 3 answers

## My knowledge of Excel has not served me well...

Within cell C2, If the content of a cell in \$A\$10:\$A\$900 is the same as the content in A2, I would like Excel to Average the contents of column H in the rows that match A2...does that even make sense?
posted by InfinateJane on Jul 2, 2008 - 6 answers

## Excel N00b

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet?
posted by chuckdarwin on Jul 4, 2007 - 6 answers

## excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group.
posted by beammeup4 on Jul 2, 2007 - 10 answers

## Excel formula question

Excel question: How to define a range so that it always adds up to a constant value.
posted by corpse on Jan 16, 2007 - 20 answers

## Excel help.

Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year)
posted by brent on Dec 27, 2006 - 4 answers

Page: 1