##
13 posts tagged with excel *and* Function.

Displaying 1 through 13 of 13. Subscribe:

## Mileage in Excel (or in something else)

There has to be a way that I can track my mileage in Excel. [more inside]

## 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!

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

Need help with (possibly?) "indirect" in Excel. [more inside]

## 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? [more inside]

## 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? [more inside]

## Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]

## Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel. [more inside]

## 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) [more inside]

## 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? [more inside]

## Excel N00b

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]

## 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. [more inside]

## Excel formula question

Excel question: How to define a range so that it always adds up to a constant value. [more inside]

## 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) [more inside]

Page:
1