1. gravanoc

    How to combine totals for a sheet with multiple entries for the same thing

    I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down about 3500 rows of data. How can I get a single row count of all their goals? For example...
  2. D

    Formula help for newbie

    Hi, i am trying to create a simple spreadsheet to track my team goalscorers, all i want is for the formula to notice a player name on one sheet and count the amount of goals he has scored on another sheet. The first sheet has the player name in column D and the amount of goals scored in that...
  3. R

    Dates smaller/ equal to or greater than

    Hi gurus, I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively. Then, they will run through a set of database (can't reveal here due to confidential purposes) to...
  4. T

    SUMProduct formula error

    Hi all, any reason why i would be getting a #Value error using the formula: =SUMPRODUCT(--(Season=$LU$2),--(home=$LV5),--(FTHomegoals+FTAwaygoals>MV3)) Season Lu2 is referencing the range of the data i wont to use Home = LV5 is pointing to the particular team & where it would be listed...
  5. P

    sum minutes in this format 45'50'60'

    I have a column of minutes from goals scored 45' 5'67'89' 2'5'89' 15'67'79'78' is there a way of adding them all up please?
  6. Z


    Hi, I have set of goals for each employee and I need to set 5 loops to include them, below is the macro that went through one goal. I need to set loop to go through all the 5 goals, how can I do that? Thank you!
  7. S

    Excel Dashboard Advice

    I am wondering if I can get suggestions from the experts here how best to proceed. I am trying to take my companies 10 sales goals and turn the monthly data into a dashboard so that my boss can quickly view progress. Each goal has a production number, goal, and deficit/surplus to goal. The goals...
  8. O

    Goal buster

    Hello, Its been a while and I hope someone can help. I have a fairly simple spreadsheet which is called Buster. It consists of various people who gamble on football teams scoring some goals or not each date they are playing. As soon as some one reaches 21 goals they win. However if they go over...
  9. O

    Data Analysis of Excel Tables - SUMIF

    <tbody> Game Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals 1 Calum Steve 3 3 1 Owen James 1 0 1 Jim Victoria 2 1 1 Peter 0 1 1 1 2 Calum Dan 4 5 2 James Steve 4 5 2 Phil Tom P 1 1 2 Tom G Dave 2 0...
  10. A

    Getting Pivot Chart to change yearly goals into month according to filtered team

    Hi Everyone, I have a data set of sales reps and their sales (date of sale, amount, team, etc). I also have a separate sheet which has goals for these folks for the full year. I've setup a pivot table and a line chart on the sales file that shows total sales for the year broken down by months...
  11. J

    Multiple variable formula

    Good morning, I have a sales sheet that I use to calculate goals based on the seniority level of each salesperson. The formula checks the amount in column "D" against the appropriate goals in "D1-D15" and returns a rating. Currently I can't just drag the formula down the entire column as there...
  12. C

    help with if then statement

    https://docs.google.com/spreadsheets/d/1REi1NFguL-hD4O6_ZDJuel20Z2aybUJPUWA_ZLdJ0Rc/edit?usp=sharing i am really sorry to bother you. i dont understand why this if statement is not working looking to reward efficiency goals with scores of 1, 2, 3 etc etc. please help!
  13. A

    Calculating a goal based on where a value falls between two other values

    Sorry, if the title doesn't make sense. Here goes: I have Sales per labor goals tiered as 3 Star, 4 Star, and 5 Star labor goals. Sales per labor goals change based on the sales number. So, basically I want to say: If their actual sales is between these numbers (sales bracket start and...
  14. L

    Question about setting a function in a weekly calendar that can modify information for a month/year.

    Hello, I couldn't find this question in my searches, but I have added a week calendar worksheet to my year calendar workbook. Each month has a different worksheet and I wanted to set a formula where I can change hours worked on a certain day in the week worksheet and that will go through each...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back