## Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

Microsoft Excel Formulas in Excel

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

Hello Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell …

I hope I can explain this correctly. I am trying to convert numbers that are less than 500 in a cell column to 500. But if a number in said cell column …

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

Hi, I’m currently trying to format cells in different columns so that when I select a duration option in one column, the rows in a different column are …

A learner has seven subjects, which include Home Language. Criteria to Pass: 40% in Home Language is compulsory, then at least 40% in any two other subjects …

Hi, I am trying to establish a formula to reference certain cells between two tables as the below. Sheet1 Sheet2 In Sheet1 Return …

Hello. I would like to use a conditional formula for dates, years and months while color assigning it based on what ifs. It is not working. For example …

so I have 36 stores numbered 1-36 in a column, right next to that is another column that shows a grade given to each store. I would like to pull all the stores …

I have a spreadsheet that contains thousands of addresses under these coulumn headings : address number Pre-directional Street Name Suffix I have pasted …

I would like to calculate a multi-point multiplication function and am having trouble. I am trying to do the following. IF the SUM of one column is equal …

The spreadsheet is a swimming gala recording sheet. On the first tab the times are recorded freely as 12345 (where that actually is 01:23.45) I would like this …

How can I have Excel count the cells in a given column which are each/individually less than the corespoding cells in multiple other columns? For example, …

Hello I am working on airline revenue analysis dashboard. Where i need to find the top 3 airline carriers based on total revenue generated …

I have a situation where I would like to add a formula to a staff schedue that will calculate how many Room Attendants to schedule. A Room Attendant can clean …

Assume the columns below start with column A: If you add up 23 weeks worth of 4’s, starting with column C (week 1), you will get a sum total of 92 …

I have two sheets. #1 has a mileage table with 11 locations to 11 locations with mileage from one location to another. Sheet #2 is a mileage reimbursement …

My payroll spread sheet utilizes a drop down list for employee names to be added to a work day. I use Vlookup to add the employees pay rate next to their name …

I have a spreadsheet of issues with start and close dates and would like to get an average of how long issues stay open for. Column A: Start Date Column …

if cell d5(the category) is STUDENT the price is 25. (hint: student must appear in quotes. do not enter $ for the price.) all other individual members must pay …

I’m trying to use an array formula with sumif and know the correct format is along the lines of …

Hi there I’m relatively new here in Excel, so pardon if this question might sound like an amateur. I’m trying to use COUNTIFs to calculate the …

Hi I have an excel sheet where are are telephone numbers in column A and the bill details are month wise in the following columns. For example: Number …

Using google docs excel. Hi, I was wondering if I can create a certain formula that only calculates age if the date of birth is inserted in nearby cell. …

Hello, I’m about to manage 3 different budgets in my place of work with no other method of tracking spend other than a spreadsheet. I would like …

Hi I have a drop down menu in d5 on sheet 1, this menu has the years in 2014,2015 etc, in d15 i want to know which item ive sold the most, and i want it …

T1 geo 1 T2 geo 1 T3 geo 1 T1 sam 2 T1 Nat 3 T2 Nat 3 …

UE Release Date Observation Month UE Rate Observations Days Daily UE data S&P 500 Date S&P 500 Close 5/6/55 4/1/55 4.7 5/6/55 5/6/55 37.889999 …

I am looking to know how many of these ID have used 1 or more benefits. The column C should say the total benefits used i.e. between 1-5, NOT the total count …

is there a way to automatically increment the date by 1 for each successive row with this as the original formula: =SUM(‘M:FY 2018 DepositsDeposit …

Hi I just have a question for the IF then Subtract command if possible. I have attached an example.. By:

I have list1 in excel file list1.xlsx. the first two cells are used in many other excel spreadsheets (different .xlsx files). I wasn to alter the first two …

Hello, I have a cell on one worksheet that calculates an average and displays the result as a percentage. I have that cell linked to another worksheet with a …

My problem is very small and basic but don’t know how to solve it. I have 2 cells A1 = value of Kg, B1 = Value of Manns (Kg/40). I want both the cells to …

I have 28 students in a list (numerical) who needs to sit for an examination in pairs. There are 4 different examiners. At any one time, there will be 4 …

Hi. Thanks for your help. I have a Project list. One column is the total of the project and the next is a drop down menu (the list is Designed, Tender, Quote, …

IFS function is not working in most of my client office.I have made a planning sheet using that with hardwork in my laptop(xl 2016) but in others pc it is not …

We have a pretty simple thing we are trying to do, which is to make a repair queue line. Column A = Name Column B = Estimate Time of Repair Column C = Status …

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.