functions /formulas

  1. N

    Counting data from an external workbook

    I have been trying to count a column of data based on specific criteria. Here is an image of my data: The data in column A is actually in an external workbook (for simplicity I am showing it all in one image here) and I am using the SUMPRODUCT function to try to count how many times any time...
  2. X

    Macro to SumIF between a date range and loop Worksheets

    Hello, I'm relatively new to macros, and need to run one that runs a loop that sums anything in 2017 in each worksheet. There are about 20 worksheets that all set up like this; Payment date Beginning Balance Monthly Payment Interest...
  3. I

    Help with IF(NOT(AND)) Conditional Formatting Formula

    Hello All, I'm working on a conditional format formula and have the first part figured out but stuck on the second part. I need conditional formatting that says, =IF(NOT($B2=0),(AND($C2<B$4,$D2>$C2))) is true then add 1 month to the Due date (column E) and highlight that calculated month...
  4. T

    Fantasy Football Team Selector

    Hi Guys. I am trying to make a fantasy football team selector that will look at the list of my players and pick the best option for the position i want to pick and i am wondering if you guys could help. I have a sheet (named squadsheet) with all my player's ratings in each and every position...
  5. E

    How to sum dashes "-" as zero?

    Hello, guys, I'm currently having the final assignment of my semester and I'm having difficulty when it comes to the part to adding up dashes as zeros. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Thursday Friday Saturday TOTAL Park Ticket Type Park Ticket Type Park...
  6. H

    How to calculate attrition rate

    I want to calculate the attrition rate in the following data set <colgroup><col span="2"><col><col><col></colgroup><tbody> effective_date hire_date UNIQUE_ID emp_id full_name 30-04-16 29-11-10 703621Peter Jones 703621 Peter Jones 31-07-16 29-11-10 703621Peter Jones 703621 Peter Jones...
  7. L

    Counti if multiple Criteia is met (if, and, countif together possible?)

    Hello, I am trying to figure out a way to get a count if certain criteria's are met including an AND function. Is this possible? Example: I am trying to get a count if Column B & C both do not equal "0", Column A equals "GC", and Column D equals "Active". Is this possible? I currently tried...
  8. P

    Adding an extra Function

    Hi, I have a problem where I need to add an extra function to a formula. I currently have the following table on a worksheet:- <tbody> A B C D E F 18 Log Cabin Quantity Size Notes Twin Skin Insulate Floor 19 Cowbeech 1 3x3 1 1 20 Brightling 21...
  9. V

    Help with Excel for Mac 2011 - Functions

    Hello all, and thank you for whatever help you can provide. I am using excel to look at historical financial data. I have used a query to pull and update historical stock data from Yahoo Finance. I need to lookup the cell with the lowest value, return that value and the date of that value to...
  10. D

    IF statement and Column Search help

    Link <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><bdo dir="ltr">=INDEX(Student,MATCH("Teacher 2",Teacher,0)) <bdo dir="ltr">=IF($A$2=INDEX(Student,MATCH("Teacher 2",Teacher,0)),OFFSET(INDEX(Student,MATCH("Teacher...
  11. C

    Function that counts values and returns them

    Hello! I work for a non-profit organization that helps special children. I have to make a table that contains children's age (among other information). I don't know how to explain what I want to do, so I will write an example: Name Age John Smith 5 John Smith 13 John Smith...
  12. M

    Moving cells

    Is there a way to move a range of cells down for eg. Say I have a value in cell d8 and I need cell c8. To c whatever to move down with there content included

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top