excel 2013 formula

So I have a sheet where I have some dates and some results, I am trying to combine a few different formulas into a single one so that I don't have to look at several columns to get my results. When I have the formulas separated, it works fine, but when I try to combine them, I don't get the...

So the new data I entered from Data Entry from cell B14 wont appear on my Summary sheet. Here's the link of my worksheet. Thanks https://drive.google.com/open?id=1ih3WugV04-LKJ90fZFUdBipvULGH7Rue

I have a workbook with the following spreadsheets: Summary, and Jul18, Aug18, Sep18 (and rest of the months going to May19). On the Summary Spreadsheet, it looks like this: A1 - Month (drop down list) A2 - Student (drop down list) A5 - Number of Assignments A7 - Number Completed A9 - %...

Hello So I have a spreadsheet (Excel 2013) with two columns for Firm Names and Address. Now for several entries, the firm name is present in both the firm name and the address column. How can I compare these two columns and strip off the firm names from the address column? How I have it...

Hi Is there a formula to solve this problem in excel: Sheet 1 – write a number in col. A à find all instances of that number in sheet 2, col. A, and the corresponding values in sheet 2 col. B. à Return the highs corresponding value in sheet 1 col B. I.e. If I write 100 in cell A3 (sheet 1) the...

Hi, At the moment the following line works fine =SUMIF($A4:$A28,INDIRECT("[File1.xlsx]Sheet1!$A$3"),$C4:$C28)+SUMIF($A4:$A28,INDIRECT("[File1.xlsx]Sheet1!$A$8"),$C4:$C28) Assuming INDIRECT("[File1.xlsx]Sheet1!$A$3") = Apple and INDIRECT("[File1.xlsx]Sheet1!$A$8") = Orange Instead of writing...

I have a sheet within a workbook which I would like to pull data from cells in another sheet which resides in another workbook. The formula to do this I have figured out, but instead of using a fixed path, I would like to use data from cells within the active sheet to populate the file path to...

I have a excel document report based one of the columns has concatenated data together with '/' it appears that most of the data is in the third position i.e. /ABC/ABC/ABC/ABC/12034. I've seen the use of mid/search but this has not worked with the third time '/' appears. All sections of the...

I'm having trouble creating a COUNTIFS function with the following information: *Criteria_range1: "AvgSummer"(column R) values on "OlympicMedals" worksheet *Criteria 1: Greater than or equal to "Tier" values in "Summer" (column D) *Criteria_range2: "AvgWinter" (column S) values on...

In cell V3 I have a time validation cell that allows the user to enter end shift time between 18:00 (6:00 pm) all the way to 17:59 (5:59 pm). Beginning before midnight is necessary because my shift is overnight that starts at 18:00. The shift can end anytime there after. Sometime the shift ends...

Hi, I've gotten pretty good with Excel formulas, but this one has me stumped. I have a Workbook with 6 worksheets, one of which is blank. I want to copy the data from all the column As into column A of the blank worksheet (creating a summary page), without including any blank cells. So, when...

This should be simple but I'm stuck for days and spent 8 hrs on this today alone. Q1 I would like to look up the number of games played on Sheet 2 in column A for the correct first and last name and place it in Sheet 1 column D. I tried =IF($A3=0,"",INDEX('Court...

I've been stumped for 3 days now and am resorting to begging for help. This EXACT same formula (put there with a filldown) works perfectly for most rows, but on some it generates the Div/0 error and I don't know why. Here is my formula: =IF(ISERROR(VLOOKUP($A119,'Input...