## excel

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

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 am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

I’m trying to use an array formula with sumif and know the correct format is along the lines of …

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …

I have a spreadsheet containing a column of numerical codes (A), some which repeat more than once in the column, and another column (B) of corresponding values …

Hi there! Currently working on something that adds hours up over 4 weeks to sum the total hours worked in a month. However, I cannot allow the spreadsheet to …

Hi All Im wondering if somebody can help I am using the below formula to calculate hours it all works apart from if a cell is empty for …

Hello guys, i need help calculatin how much money has been paid for a specific transport company for a certain month. For example sum the last columnt if the …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet. Some of these values will result in a blank because …

I have a list of data, exported to excel, which has ‘TRUE’ or ‘FALSE’ in a column, based on if they checked a box on a previous form. …

Hi there, I am trying to sum the largest n values in a range and I would like to specify the n by using a cell. What I am trying to achieve is …

I’m trying to find out if there’s a way to dreate a drop down menu where each menu item has a value associated with it, and could then create …

I’m trying to use a SUMPRODUCT formula to add multiple rows together based off a couple different criteria. When I do it for just one row I can get it to …

I need to add the values of two cells, however, one of the cells can only count up to 8 points. For example, cell B3 = 10 and cell B4 = 24. All of cell …

I am doing an expense report with many different expense users. They each have their own expense sheet within the same workbook. I have created a drop down …

Hi I have two worksheets. One listing all days against a individual contract e.g. Contracts Days 1234 …

Is it possible? excel By:

Hello As the numbers below is imported I can not use auto sum. Beside from the m at the end (easy fix) I have one to four spaces in front of the number. How …

Okay, so I have a spreadsheet as shown above. I want to capture the statistics for my football team’s individual players for each game. The format is …