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

Microsoft Excel Formulas in Excel

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 …

A B C D E F 1 Date Batch 1 1st Time batch 2 2nd Time Hour 2 28/1/19 AA103 BB100 6:09am 0.75hrs 3 28/1/19 AA104 BB101 6:15am 1.23hrs 4 …

Key Word Store Name Key Word Result Pharmacy all in all grocery Grocery health pharmacy 2365 …

Hello…My name is Robert, and I am an intermediate school math teacher. The following formula works for me, but I also need to a assign a value of zero …

How do I set up a column to average a row of numbers? Example: Number Average 120 120 125 123 200 148 I want to make the cells in the …

Hi all, I need to calculate the rental period for a widget between a start date and an end date. This rental period has to be broken down as …

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

what is the formula for a 10% discount up to $4000, with a maximum discount of $400. Thanks. By:

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

Hi, I am looking for some support regarding the below issue. A B C D Lead Time Example Wk 36 2019 Wk 50 2020 19 If (CD + Lead Time is less …

Suggest a formula for the below problem: Consider Sheet 2 of the attached file: As you can see two cells i.e. H17 & I17 are highlighted. When two …

Hi there, I am using excel and need some assistance. I have 2 columns of data. The first column is a list of countries and the second column is a list of …

Hey there! I’m new here and having trouble setting up a formula that will return a value based on a tiered billing. Example: A1 …

Hi , Thanks in advance for your time. I am trying to figure out a formula to help me return data fields that match information in columns. …

How can I make it so that when I input a number into Worksheet 1, cell B1(#household members), B2 updates with the corresponding number …

I wanted to create a formula that can detect if the value’s decimal in the cell is over .60 and if true then to subtract 0.4. So I have 38922.64 …

Can anybody suggest a way to check whether any three consecutive cells in a column are equal? Anywhere in the column, but there must be three identical values …

Hi hope you can help Is there a formula where I can get column D to equal column C, if column A is equal or < 0.01 or > 0.01 A …

Dear Spreadsheet warriors i’m trying to create a project number generator using excel by choosing from a selection as per the spreadsheet provided …

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named …

I wrote the following formula and it works for 11 of the 12 months. I cannot get it to work for January. It is written the same way except for the last …

I have a set of rows with a start time and end time each. Each row represents the duration for usage of a resource. What I need to understand is …

I am using Excel 2013 I want a formula to tell put in F2 “A”, “B”, “C”, “D” based on a number in B2; the …

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.