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

Microsoft Excel Formulas in Excel

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 …

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 …

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 …

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 …

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

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

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

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

Quesion: Input Column A Column B Row A1 XXX …

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.