# Archive by category Excel Formulas

Microsoft Excel Formulas in Excel

## Count if X is used in 2 coumns

Hello,   I have two columns column E and column F. some cells have a X and some dont. I’ve tried using countif but it counts the rows that have …

## Excel formula

I need an excel formula to get value for that the conditions are, 100% up to the value of 15000 and above that 25% of value up to the value of 25000, so the …

## If cell contains two values, count each value as .5

I have a sheet that calculates number of real estate listings each agent has taken. However, sometimes, 2 agents will split a listing. When this happens, the …

## Tricky formula required

Dear clever ones, Please can you help? I have individual staff sheets that map allocation.  I have a front sheet which shows the allocation for each …

## How many Hours?

I’m trying to get the exact hours using… If 70 = 1 hour and I have 50, 100, 200, 300, 400, 500. How many hours is 500. How many hours are 300, etc. …

## If/Or Function Help

I think I have the first part of this solved but can’t seem to figure our the second part with Job Status. =IF(OR([@[Pay Grade]]=”D”), …

## How to construct an Excel formula that will average non contigous cells in the same column

My worksheet is used as a daily log containing such information as “Date”, “Actual Weight”, “Target Weight”, “Average …

## Display Value after Matching from Two Separate Tables

What would be the formulat to to display the unit “Three” in Column H if given the unit “Two” and “Four”? It would have to …

## copy/pasting formulas

I want to copy/past a cost breakdown and have certain cells reference a list that does not have equal cell spacing. For example, I want A1 to equal C1, and …

## Conditional Formatting Excel 2016

I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …

## Mulit Key lookup across multiple sheets

I have two very larges sheets (45,000 Row, BL colloums each). Each sheet has the same columns in the same order but the row data is not necessairly in the same …

## Sum whole Row

Is there  a simpler way to achieve  =((Attendance!\$C\$3*Attendance!C5))+ …

## comparing two collumns and inserting collumn when not matched

Comparing 2 collumns from 2 different groups having a empty collumn between the groups , each group containing 4 collumns, inserting the cell in every collumn …

## Applying percentage to entire column

Hi, I’m a beginnger in using Excel 2013 here but i do know how to use the basic functions ie. (SUM, ROUNDUP etc…) Is it possible to have a function …

## +1 Between Time Ranges

I have a matrix I am working on. The matrix ranges from 0000-2330 Monday-Sunday (Columns P-V,4-49). I need a formula to get a +1 count for each person working …

## Serial number to the Subtotal Rows alone

Had a Excel Data. Subtotal was done. Want serial Number for the Subtotal rows alone. How to do It ? By:

## Find a specific cell by using a row and data in rows and columns

I have a spreadsheet A5 through A11 is ABCDEFG. B5 through H11 has (101,102, 103….) number data in it. B4 throughH4 is 1,2,3,4,5,6,7 I need to wirte a …

## Match/Index Formula for Text Data

I want to return ALL rows that contain a certain TEXT from a single column.  Example: Sheet 1 contains data columns A to Z, in which data will be added …

## EXCEL FORMULA

PLease help me with this: Christine is a new homebuyer. She wants to make sure that she incorporates the cost of maintenance into her decision. She estimates …

## USE EXCEL TO SOLVE FINANCE EXCERCISE

Someone helps me with this. Thank you. College tuition has been rising at a rate of 7% per year. Currently the average tuition of a state college is …

## Compare and Match

I have a report which shows the ID#s and the names corresponding to those IDs. I am trying to write a formula which check the ID# and see if the same ID#s have …

## dynamic named range

Hello,  I have two columns, Name and Tag Name    Tag AAA BBB       Yes CCC DDD      Yes      …

## EXCEL 2013: Dynamic/Unique value search from pivot

Hello,  So I’m trying to built a formula from a pivot, so I can then enter it in a macro and prevent manual work. The problem …

## Student

I have a table in which the students attendance in 10 classes is codded by Y(yes) and N(no). how can i put the attendance grade using an excel formula knowing …

## Questions about my Excel works

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

## excel RMS formula

I am looking for a formula to (x) squared + (x) squared etc divided by total number  and then the square root of that number.   I have a colum of …

## Incentive calculation using slab

Monthly Ach% >2.50 2.51-5.00 5.01-7.00 7.01-10.00 <10 <90% 100 200 300 400 500 95-99% 200 400 600 800 1000 100-104% 400 800 1200 1600 2000 105-109% …

## How to subtract cells with previous embedded formulas

I am trying to subtract two totals in the same column. One of the totals is a result of a SUM formula. I think I need an IF formula, but don’t know how …

## Formula to pull numbers from the range of data

I need formula that pulls Q4 value into P2:P4 and Q8 value into P5:P8. Pulling it into P2:P3 and P5:P7 works too.     By:

Looking for formula so I can create an email address from a name in an Excel document when the first and last name is in one cell with a space in between the …

## How to incrase last number of alphanumeric text.

Hello All,   I have column A having Purchase Order Number and in column B having supplier name. Now I have short them wtih Supplier Name and PON. Now I …

## Detecting Duplicates within a sentence

Row 1: 123, 456, 789 Row 2: 123 123 appeared twice. How do I detect 123 as a duplicate? From my limited knowledge ,i only managed to detect the duplicate if …

## Basis Points as Calculated Field in a Pivot

Hi I’m trying to find the right formula to put in the Pivot table in order to calculate the BPS (Basis Points) difference between 2015 and 2017 market …

## Sumif to find sum of values with a given name in a given month

Trying to find a sumif formula that will return the sum of values with a given name in a given month. I have multiple entries within each month that are …

## How would I solve this problem?

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 …

## Excel fomula for “Table Summary”

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …

## Excel Formula error

I just put the formula of averageifs in the sheet to with linked to database which is sheet one when drag the row downward it shows an error”the …

## Count Multiple Values

Hi, I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to …

## how i can calculate these sheet please on excel

NOTES                 1. Use a formula to find the appropriate hire category in the above table       2. …

## Same value in one column and the adjacent column cells have different values, How to put different values of the adjacent column in to a single row?

Quesion: Input               Column A     Column B  Row A1       XXX    …