12 posts tagged with excel and Function.
Displaying 1 through 12 of 12. Subscribe:

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. [more inside]
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? [more inside]
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? [more inside]
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? [more inside]
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel. [more inside]
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) [more inside]
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? [more inside]
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? [more inside]
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. [more inside]
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. [more inside]
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) [more inside]
posted by brent on Dec 27, 2006 - 4 answers

Page: 1