## Summing Multiple Index-Match Formulas

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 …

## Complex Formula

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 …

## Sum If Array Formula Question

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

## Calculating a sum of certain data based on other dats

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 …

## Create list of unique cells

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 …

## How to sum cells while ignoring ones with text in the same sum?

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 …

## Formula Substitute Help

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 …

## Sumproduct Name and Date criteria

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 …

## Creating an excel formulae with multiple options

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 …

## How to sum multiple rows and columns

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 …

## Sum letter and his value

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 …

## SUM formulas

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 …

## Alternating TRUE & FALSE values – Count

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

## Sum Largest 1:n values. Using a specidied cell to define n

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 …

## SUMPRODUCT Question

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 …

## SUM two cells, but one cell is only worth 8 max

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 …

## Condensing data from a drop down list

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 …

## EXCEL HELP NEEDED

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

## Is it possible for a number input in a cell be added to another cell?

Is it possible?   excel By:

## Remove Spaces from Start of Cell

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 …

## Summing MID Function Results in One Cell

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 …