## Excel 2016 – IF Function – Sum Times for Specific Name/Date

I am trying to set up a spreadsheet into which I can dump a month’s worth of appointment dates, times, and visit durations for a variety of people. I …

I am trying to set up a spreadsheet into which I can dump a month’s worth of appointment dates, times, and visit durations for a variety of people. I …

I have created a link to a website: no big deal. I am trying to get a formula to ‘add’ the number from an adjacent cell A1, A2, etc. to search at …

I need a workbook to keep up with cash paid out and received daily. I would like to have multiple sheets for each month (example – dec. 1st, dec. 2nd, …

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. The cost of packaging is $1.50 and it takes 5 …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

Hello, so I am trying to create a volunteer hour tracker for my organization where people will go in add their name and other information about their …

Hello, I am trying to do a chart and need to edit the X-Axis. I see where you can edit the increments, but is there anyway to do two different …

I’m looking to get assistance on how to count the number of employees who servered customers during each hour, of each day. I have the employee name, …

Hello all, I need help using excel formulas to figure out the date and time of deadlines. I don’t need a timer since the spreasheet will only be to see …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

If you take (A1-A2)/A2 , what does this formula give you? Let’s say you’re doing a YOY comparison, if A1 is April 2017 and A2 is April 2016, would …

Hello! I am currently working on a workbook involving inventory on each sheet. On my cover sheet I have a summary of all of the rooms where …

Hi, I have a table that looks like this: C denotes columns C1 C2 C3 A B C A E F A B E A B C A B D I know I can use index match to match against two criteria …

I made a Data Entry Form that ads or updates rows in a datasheet. With this http://www.contextures.com/exceldataentryupdateform.html as the base. The …

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1. …

Hi, Need help from excel experts . I need to do data comparison and consolidation between 2 excel files, which have employee leave data in different formats. …

Thank you in adavace, you’ll be saving hours in the day. Ok, so I have a couple hundred items for sale on Amazon. When i try to get any kind of report, …

Hi there, I am somewhat new to excel and was hoping if someone could help me with this. I am using excel to track some proejcts that I am currently working on …

Hi! I am having problems figuring out an Excel formula. This is for Excel 2010 on a Windows PC. I want to enter a number in one cell, then display a …

I am trying to create an if/then function with text…every way i write it i get error..I want to make it so if 2 cells that are adjacent both contain …

Hi I receive every month the same data in an excell file.I would like to create a new sheet in this file with the same data (and some calculations) in order to …

Hi There, I am trying to create a formula to count the amount of forms returned by a department. The database is set up in a way as such: …

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns. The 3 …

I have a worksheet where I have calculated placings from 1st to 49th (this number will change on each worksheet – sometimes more, sometimes less). I …

I would like to obtain a percentage of accuracy for a box office prediction site. For example let’s say i have this: A1 Predicted Gross / B1 Actual …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.