# Archive by category Excel Formulas

Microsoft Excel Formulas in Excel

## Question****

Dear Sir/Madam,   Data, 23,45,87,31,2,3,65,50,3,45,85   Question: How to formulate the above data from left to right when the addition is more than …

## 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 …

## Conditional Formatting

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 …

## 500 min formula

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 …

## Compare two values in an array and if they match in a row, return a value from the third column in the same row.

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 …

## Excel Conditional Formatting

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 …

## Mr

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 …

## Formula needed

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

## Excel Learner

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 …

## Formula help

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 …

## Formula help

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

## Calculate Multi-Look Up Product Formula

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 …

## Excel data and formatting changes across sheets

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 …

## COUNTIFS for multiple ranges

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, …

## To find top n values based on criteria

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

## Scheduling Formula Multiple Facotrs

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 …

## SUM A RANGE BASED ON A SPECIFIC CELL VALUE

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 …

## Payroll

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 …

## Average of numbers that came from another formula

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 formula

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 …

## Sum If Array Formula Question

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

## Formula for COUNTIFS

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  …

## Calculate age formula to only show when data is added

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. …

## Counting Cells based on two sets of specific criteria

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 …

## formula

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 …

## duplication

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

## Require help with an excel formula

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 …

## IFS and COUNTIFS

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 …

## change embedded date automatically

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 …

## IF THEN SUBTRACT FORMULA

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

## Communication between two independent spread sheets.

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 …

## Cell not returning result with if then

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 …

## Student

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 …

## Random Categorisation

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 …

## totals for different ‘data validation’

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 not working

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 …

## Creating a Line Queue

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 …