excel formula

Hi, I am using Office 365. I've tried the Concatenation approach and using a Vlookup, but I think it isn't working because the cell contains both numbers and text. I spent a while trying to sort that out, but I think my files have formatting issues, even after using the TEXT function, so would...

Hi, I'm trying to calculate a formula that if the result is less than zero then it returns the delta value but is capped at zero instead of the negative result and to then show the residual amount in the cell next to it. For instance cell A2=+20, cell B2=-70, cell C2 should be A1+B1 which...

Hello everyone, I am desperate with this challenge. 1 3 4 3 4 3 6 5 5 2 I need to sum the above column with the below criteria: 1. Sum values only once (as some values will be duplicated) 2. The value must be more than 3. So I need it as 4+5+6=15 I was able to satisfy the first condition by...

Instead of =COUNTA(A11:A5000) below formula automatically adjusts to however many rows with data, instead of limiting to 5000 rows, or putting a million rows: =MATCH("zzz",A:A)-10 Tried to incorporate same solution into =SUBTOTAL(103,A11:A5000) with =SUBTOTAL(103,(MATCH("zzz",A:A)-10)) and...

Hello all Racking my brain trying to create an Excel formula that gets the outputs on the two right columns. I want column C to only SUM the positive numbers within each Group under Column A, otherwise populate a $0 if it runs into a negative value. Then column D would be the inverse - SUM...

I have three columns in sheet1, Name ( in Column A), Secret code (Column B), and Secret Name (Column C). If any part of the name ( in Column A) matches with the Secret code ( in Column B), and Secret Name (in Column C).then partially color the matches. If a cell or row is empty then jump to the...

I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...

Hi Team, I am trying to create a price calculator. It is a bit tough and i am not good at these complex logics. kind of subscription model. Can you please help. Logic : 1. Select a product ( there are 10 different products) 2. Select the type of agreement ( three are 5 different options) 3...

Dear Excel wizards, I am trying to find an Excel non-VBA formula to automatically calculate the end-of-year holiday week based on the available yearly data. These are the holiday data (including the 25th of December and the 1st and 2nd of January the next year): Monday 26 - Friday 30...

I am needing to COUNTIF column B on "Data" sheet is greater than column C on "Data" sheet, if the name in column A of "Totals" sheet matches the name from column A on "Data" sheet. The Data sheet has multiple rows with the same name that need to have the values in B and C checked. Data Sheet...

(1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...

How do you sum up different cells with different input? what i'm trying to to do is to have a formula that will sum up the gas product i used. In my excel i have 3 diffrent gas product but i used different gas product at the same time or sometimes the same gas product. Is there a formula that...

PLS HELP. I LIKE TO CREATE A FORMULA BUT I DON'T KNOW HOW TO INPUT THE CORRECT FORMULA. WHAT LIKE IS TO HAVE A FORMULA THAT WILL AUTOMATICALLY CALCULATE DEFENDING TO WHICH GASOLINE PRODUCT I CHOICE TO CONSUME AND AUTOMATICALLY SUM UP, IF HOW MUCH I CONSUME ON EACH PRODUCT. NEVERMINE THE...

Hello, I'm trying to calculate the number of months past due from a given date. For example: If my date is given as 06/25/2020 I would like to see in the new column how many months this is overdue from 06/26/2020 to the previous month (Feb 2022). Thank you for your help in this matter.

Hello i have the formula below and it is referencing another cell on another sheet, and when that cell does have info in it the formula does what it needs to. However, when that cell it is referencing in 'List' is empty the formula is placing a '0' which i would rather it be blank still and not...

Hello I have this formula I am trying to get to work and it is leaving the cell place when I have an X in T5 and the word First Class is on b33 on the page this page I was wondering what I am doing wrong? I am trying to do is if First class is on cell b33 on page This Page then do the following...

Hello, i am trying to get this conditional format down to where on my sheet on cells D16 and E16 are greyed out and or also crossed out of the cell b33 = "Last" on sheet "Check Off". Thank you in advance!

Hi! I've had great success in the past here with VBA macros so I thought I would try my luck again. I pasted some mini sheets as an example, hopefully I did it correctly... I need to converge 2 spreadsheet given the following scenario: Spreadsheet 1 entitled "total_siteA.xlsx" with a sheet...