## How to Sum?

How to Sum Values in a cells if : cell shows 5 (7/14) which is number 5 on the date (7/14) I need to get my row to sum and ignore the 7/14 inside the …

Excel 2010 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

How to Sum Values in a cells if : cell shows 5 (7/14) which is number 5 on the date (7/14) I need to get my row to sum and ignore the 7/14 inside the …

Hi, I would like to match the numbericals values between ROW & Column and the matched insectign values should be mentioned in the empty column. Can you …

Hoping to get some help, I have a sheet with one of the columns representing the start time for a task as a custom category of d/mm/yyyy h:mm I am …

Sample Text Which I Receive Sample Text Which I Receive FLAGS STAMP# DATE EXP: 1 FLAGS …

I have columns of dates and times that fleet vehicles have been taken out of service (OOS), and a second set of columns in which the vehicles have returned …

Hi, I require a formula to count the first 20 entries which are reporting as ‘Ongoing’ and which have a scoring of 21 and above. …

Greetings! I am trying to create a macro in excel for the first time. I have 365 files (of similar format) and would like to count the number of cells …

Sceanrio: I have a table with 3-dimensional data (few column headers merged). Cells A1& A2 merged with title “Part name”,Cells B1&C1 merged …

Hi, I want to calculate between to columns. For example I have two columns one for time in minutes and one for time in hours. I want to be able to write …

i have a list of names / salaries that extend multiple years (columns). i would like to add a function that i can turn on/off cells representing salary to see …

I have two worksheets. First worksheet is updated with new data every week. Is it possible to automatically update the second worksheet based on the changes …

I have a large spreadsheet I use to analyze data. Currently I’m stuck trying to get it to count values of a column that have time values between two …

Hello, I need Cell C2 to return “Yes” if any cell in column A=A2, and that row’s B=”Not Paid”. I.E. If A6 matches A2, and …

whats the formular that calculate the different amount of months between 2 given dates? exp: first cell (25/5/1992) second cell (17/6/2018) …

Hello, I’m hoping you can assist me in reducing manual input with some fancy formulas I know Excel can offer. I currently have a report …

I need to extract the rows that contain specific valued data. E.g if I use the CTRL F command and search for some specific value, the search appears. Then I …

HELLO I’LL LIKE TO DO IN MACRO IN EXCEL THE FOLLOWING: I HAVE A COLUMN WITH NUMBERS LIKE IN THE EXAMPLE BELLOW: 1 1 1 2 2 2 3 3 3 I’LL …

Need to check if there is a trend in wind speed along the hours of the day for a 2 month period. So in Column A I have the hours in 00:00 to 23:00 format for …

I have two customer lists, both from different systems. 1st list is a reference list of existing active accounts, while 2nd list is from an acquisition. …

I would like to match names in column A to names in column D and return D. By:

I would like to sum multiple index-match formulas in one cell. Trying to manually add them led me to a character limit error. I want to multiply two …

I have 4 forms on one worksheet. (They are related to each other) I want to save each form individually to desktop with a command button. Kindly assist with …

I am trying to write a code in VBA to change the tab color based on cell value. The code I have now works when I manually input the key word. However, the cell …

I am trying to subtract time values but only if the original cell is not 0. L15 is a static value of 6:30 (6 hours and 30 min). I am subtracting cell G12 but …

Dear, i want solution for the below case, i want to add Male/Female Automatically Based On Mr./Mrs/Ms By using IF formula. like If 1st word of the cell = Mr. …

Need help with the formula of cells highligted in red & if the excel could get even simpler By:

I have the table below and would like to extract the room nights and the room revenue per month to another sheet. What formula do I put in the other sheet to …

Dear Concerned, I am having problem on using excel. I will explain my problem and pls tell me how to get things done. I’m working in a small …

What are the advantages of creating aggregates using sumifs() rather than using a pivot Table? Kindly help in choosing three that applies from below: 1. …

Hi – thank you for any thoughts on this – grateful for your time. Here’s a formula that calcs a weighted average within a data table. …

Hi, So my boss gave me a project. We are a shoe company with many many skus, she wanted me to create an excel spreadsheet that could automatically populate our …

Find all the values in array1 that correspond to a number in Array2, i.e., for # “8”, the return would be “Al”, “Bt”. For # …

Hi, I would like to know what formula we can use to get the forcast of the PRE QA numbers from the disqualification trend we are having? for example: if …

I’m doing a spread sheet which involves circular references. The iterations function has been enabled to allow the circular references to work. Basically …

Im using windows 10 and excel2010 I am trying to come up with a formula that finds the highest ascending number in a sequence, the numbers are across columns …

i’m still relatively new to excel. i’ve been working 15+ hours on this sheet and figured there must be a faster way to do this. essentially, …

I have a column of 6 cells and I only want the top 4 summed up in another cell, how can this be done? By:

SEVRENE® 3000-70A-8870 XDV DARK SLATE Is there an If statement that would pick out SEVERENE from the above, change SEVERENE to SEV in another column, and …

I want excel to pick the two largest of three numbers where the cells are not adjacent. Example; total two largest numbers out of D4, G4, J4. Thank you for …

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.