# excel formula

1. ### Formula for end-of-year holiday week

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...
2. ### COUNTIF w/ greater than & name match

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...
3. ### How Get Question Reference

(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...
4. ### How to sum up with different input?

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...
5. ### how create a formula that is autocalculate?

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

7. ### Excel formula to calculate number of months over due

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.
8. ### Formula referencing another cell showing 0 when referenced cell is blank

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...
9. ### Double IF with OR Formula leaving cell blank

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...
10. ### Conditional format to grey/cross out cell(s) if a cell value in another page is a specific value

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!
11. ### Converge 2 data centers with VBA

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...
12. ### VBA: Delete lines in cells starting with an alphabet

I am looking for a simple VBA code to Delete lines in cells starting with an alphabet. In each cell in column c, there is a multiline text starting with numbers, special characters, and words. I also delete the space before them if any. Some cells are empty.
13. ### Need Zeros and Blanks as a Criteria in SUMIFS

I'm stuck! I've been trying to figure this out for hours now. I have the following formula below: =SUMIFS('July - Present'!O:O, 'July - Present'!A:A,">="&DATE(2021,10,1), 'July - Present'!A:A,"<="&DATE(2021,10,31), 'July - Present'!Q:Q,"", 'July - Present'!R:R,"", 'July - Present'!S:S,"") The...
14. ### New to this

I’m trying to link the square footage on the Taxes worksheet to the lot number (G8 on sheet1). That way, when I enter the lot number on G8 it automatically pulls the corresponding square footage into the calculation on the taxes sheet and puts the result in cell G41 on Sheet 1. Thanks!!!
15. ### SUMIF with VLOOKUP

Hi Gurus, Any thoughts on what would be the right sumif lookup formula for below scenario? Sheet 1 - I have a long list of Data. Simple example below: Name Change Sam 250 Mike 300 Sam -500 Mike -150 Sam -50 Mike -25 Sheet 2 - I'm having a hard time doing it in pivot so just...
16. ### Formula for a single list of Dates from two payment cycles and a list of fix dates

Can we build a single formula to auto-populate the list of dates as shown in column 'G', based on the payment cycles set in (i) & (ii) and the list of dates provided in (iii), without repeating common dates between them? For now, I prepared separate list of dates using formulas to calculate...
17. ### Extract words before brackets based on number of characters within closed brackets

Hi Friends, I looked some posts over here on how to extract words before closed backets and based on number of characters/letters within closed brackets. I am looking to do this with formula/vba/udf. Here is an example Designed and developed the application using Java Server Faces (JSF)...
18. ### SUMPRODUCT inside Dynamic Array with CHOOSE - impossible?

Hi! So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product. As you can see the result is 0 for each row. This is just an example of my real problem with a report of 200K...
19. ### Excel Formula IF

Hi Guys I have the following formula =IF(H2>=F2,"withinsla",IF(H2<F2,"slabreached")) The above formula works well I want to add the following in the formula if H2=Q2 ,"urgent" Thanks and Regards rakesh
20. ### Days Aging Formula (# of days overdue)

I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be... Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle. ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back