## SUM IF

First, anyone and everyone that can help me it is much appreciated. I am a new user here with some level of Excel experience–just not advanced by my …

First, anyone and everyone that can help me it is much appreciated. I am a new user here with some level of Excel experience–just not advanced by my …

Hi, Hope someone can help automate my invoicing process a little. I have a folder where I keep my excel invoices to customers. The invoice …

I need a a formula where i can limit a bonus for a sales rep as follows: If the sales rep closes a deal over 1000$ the bonus (50% or 100%) will be limited to …

Excel 2016 – windows 10 I have a large table with hundreds of rows… I want to be able to filter my “description” column with a slicer …

I am trying to change the way I enter time in a cell. Currently I have to type 13:00 to get 1 PM in the cell. I would like to be able to type 1300 to get 1 PM …

I have the following formula which gives me 1st 2nd 3rd, but if there is a tie it skips i.e. 1st 2nd 2nd 4th etc. Iis there something I can add to fix this …

I’m using vlookup to populate a tally spreadsheet. It is working very well when the lookup value is a regular number – like 21073 (classified …

I am trying to compile a list from a master data tab. I have another cell that my users would select their customer from a drop down. What I need is a small …

Hi, I was wondering if you would be able to answer my question. I am using Excel 2013 and I have roughly 20 spreadsheets inside populated with data, at …

By:

Hi There, I have a question regarding graph plots. We use x/y graphs to plot certain performance curves. We have say about 6 or so x/y plots …

I want to automatiacally bring data from different tab within same worksheet. I have a summary tab, that will show summary of many detailed tabs. I want …

Hello, I have two tables with different data, in both of them there is time written. I want to match the values where the time is the same (plus minus …

how to change 32642/319/09-07-08 only change 32642-319/09-07-08 this format all sheet only change firt / to – not change all By:

how to change 32642/319/09-07-08 only change 32642-319/09-07-08 this format all sheet only change firt / to – not change all By:

Hi, I am completeley lost on this and would appreciate some help,… am able to ‘fiddle’ with excel formulas, but this is way beyond me. …

Hi, I need to create a hyperlink to a cell in excel, but I need the hyperlink to change when I move that cell to another position in the sheet, so the trick of …

I have an excel list of about 5000 alumni with numerous columns of different information.I frequently use this list to create smaller more focused lists (e.g. …

I have this formula… =IFERROR((AP12-AO12+(AP12<AO12))*24,)-0.5 which works fine..but if the result was a negative number….i would like it …

Hi all, The past few days I have been searching for a solution to my problem without any success. Hopefully someone can help me out. My Excel knowledge is …

I have two workbooks, I need to look up a2:a3 in workbook 1 and if it matches in workbook 2 then I need it to put in a different cell Example: …

Need a formula to calculate layered page costs: Pages 1-20 @ $1.46/pagePages 21-60 @ $1.08/pagePages 61+ @ $0.36/page For example if I have cell A1 = 38 I need …

I need a formula to look at total volume, and from this figure work out optimal amount of shipping containers to purchase to accommodate the volume. …

Hello, I hope someone can help. I am trying to right a Macro/formula to enable me to transfer certain data from one worksheet to another. There are two ways I …

Hello Everyone, I have data that is updated everyday, and I applied (if) formula to analyis the data, but my problem is when I add new data i need to select …

Hi excel gurus, I am trying to capture a certain word or sentence and outputting them as something else in excel. For example, under column M, there are a …

Hi… Not great with excel and trying to solve (what is probably) a v. simple problem. Using Excel 2013 I have cell A1 which may have text (ie COL) …

A couple of users in the office are having trouble with images in their footers and headers warping or their margins are slightly offset whenever they open the …

Can yo help me with a few formulas? Here is the issue. Major League Baseball Service Time….172 days on an active roster equates to 1 year of ML …

Hi, I have a very large data set to work on. I am looking to search the entire table for a particular ID dynamically(1-10), and every next row it should …

dear Sir i need an automaticly Fourmals To Mix Numbers as shown in below photo I need to mix at toghether For Example: L30 2 2 1 3 4 on 10 = 150 …

On Sheet 1 I have a table that has a beer name in merged cells D1:G1 as my header. In D2:G2 i have subheaders 50 L Produced, Loss, 50 L In Bright, 50 L …

I need to translate a 5 digit Serial Number written in letters to a number. While each Letter represents a different number: A = 0, B = 1, C = 3, D = 4, E = 5, …

My question is: I have 3 columns. one with original value. other with new value. 3rd one has a value that will contain original value. I need to find …

Hello. I am looking to create a macro in excel that will combine text from one cell to the adjacent cell and then delelte and shift cells left for the copied …

Hi, I am working with excel 2007 in windows xp. I tried researching but cant figur the following out: I have a source code sheet with three different columns …

I continue to get an error message where it states the below: “Microsoft Excel cant insert new cells because it would push non-empty …

I would like a formula to sum the second digit of the number in every row. An example would be: 2302 4322 4491 3305 The sum would be 13 (3+3+4+3) …

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.