# sum across columns

1. ### SUM rows based on multiple criteria and insert below

So what i need to do is sum the values in the Units and amount columns if : - the person is the same - "x" starting number of characters is same in the desc column (ex. one__ or three____) - the Cur being "U" Then i need to insert a new BOLDED row underneath each change in colour in the rows...
2. ### Tidy up/reduce a formula to make it easier to maintain

Hiya, Is there anyway I could tidy up/reduce this formula to still get the same outcome? I'm basically trying to sum up all the cells across multiple columns where the criteria matches the content of two seperate cells in another worksheet. Example: Based on the two sheets below - I wanted...
3. ### How do I multiply 2 cells if a 3rd contains certain text

Hi I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows <tbody> Col A Col B Col C Row A Q1 5 1 Row B Q1 2 Row C Q2 1 1 Row D Q1 6 1 Row E Q4 3 </tbody> In my spreadsheet I have to repeat...
4. ### Dynamic Cell Range within SUMPRODUCT/SUMIF formula

Dear all, I require a dynamic cell range within the SUMPRODUCT/SUMIF formula so that I can sum up the sales for a product if it is defined both individually and within a portfolio (Adidas) and Portfolio (Adidas/Nike) within the calculation table. =SUMPRODUCT(SUMIF(D:D,H4:H5,E:E)) As shown in...
5. ### sum from multiple columns based on criteria in multiple columns and embedded in header

Please see example - I will try to explain, but the visual aid is probably required to understand what I am trying to do: I have many columns in a spreadsheet and every fourth column has state abbreviations with data in the next and second to next columns. I want to sum up all this data in all...
6. ### Sumifs across rows and columns

I have a data set with unique id numbers down the left hand colum and dates (week commencing) across the top. For each unique ID I want to sum the data if it falls under a specific month. So for example I want to say for the unique id number, if the date contains the month of october then sum...
7. ### Summing Across Tables

I'm sorry if this question has been asked before--I'm not quite sure how to search for it. I need to get the sum of a series of multiplications, but don't want to have to write them out line by line. An example of the data being worked with: So the only thing I can think of is to do...
8. ### Return a SUM based on month

I have a work book that shows financial data in columnar format and I'm trying to create a summary sheet that will pull through the sum of the correct amount of months when specified. I have a drop down box with the months in, and these feed a cell that gives the corresponding number (i.e. Jan...
9. ### Formula Help

Hello Experts, I have been working out different formulas to sum up values based on two multiple conditions and the problem being it has to add the value of the existing and the new found value. I have used sumifs but its only showing the TAX amount. please help <tbody> <tbody>...
10. ### Sum values in one column based on unique, filtered values in another

Please help me! I'm trying to sum filtered values from column J (course credits) based on unique values from column F (unique course ID). The desired result would return a count of 3 unique values (courses) for column F and a subtotal of 10 (credits) for column J. <tbody> A B C D E...
11. ### Array formula needed to return a sum of range

I am in need of a formula (I'm assuming an array which is slightly out of my comfort zone) to return a sum. Essentially I need to return a sum value of multiple columns based on a lookup value, but cannot use VLOOKUP since I want to return the sum of multiple columns. <tbody> Item #: Sum of...
12. ### Formula Question

I have an inventory sheet which includes weekly Purchases and I am looking for a way to add the units purchased for each week...then multiply that total by the purchase price and keep a running total for all items in the list. Example: Week1 Week2 Week3 Week4 Week5 Purchase...
13. ### Summing on Cust_ID, and Date Range Criteria

Hi, I have two tables: 1) Tbl1 is a user input table and 2) Tbl2 is a pivot table of sales data by Cust_ID and YearMonth. Below is just a sample data, but you can imagine the pivot table can get quite large due to the number customers and YearMonths. Instead of manually updating the pivot...
14. ### Sum of SUMPRODUCTS

I have a scheduling worksheet that tracks weekly time. I have a formula that determines the cost associated with time off for a resource within a week on the schedule...
15. ### Selected Sum

Hi, I have simple table: <tbody> A1: Country B1: Value A2: Poland 10 A3: USA 5 A4: Germany 2 A5: Poland 5 A6: UK 3 A7: Germany 3 A8: Poland 2 A9: Total =Sum(B2:B8) = 30 </tbody> Now when I'm using filter and select Country = Poland, the total should be: 10+5+2=9. But always...
16. ### Sum across columns based on criteria of column label

<tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD Total YE Actual Actual Actual Actual Actual Actual Actual FCST FCST FCST FCST FCST YTD All pt1 10 10 10 10 15 15 15 20 20 20 30 30 85 205 pt2 pt3...
17. ### Sumifs using name ranges

I am trying to sum a column using multiple variables in named ranges. So far i have only been able to get the formula to work using one or a few of the criteria. I started with this but it's not working. "=SUM(SUMIFS(Amount,Dept,{"Boston","Atlanta"},PartNo,{"PYFO","PYRH"}))". Below is a...
18. ### Countif, Sumif , or Sum Help

Hi there everyone. What i would like to be able to do is count specific cells in a range that contain text. So i am able to find the total amount of cells that count text in that range i have copied an Example data set below. i like to count the Comp1 , Comp2 , Comp3 cells for each person...
19. ### Help - Summing With a Many to Many Relationship

Can someone kindly help me, I am so stuck! My boss made a workplan in Excel and we want to sum the number of hours each person has of work in a month across all tasks. The output table should show something like this <tbody> Name Jan Feb Mar Person 1 4 2 Person 2 1 7 55 </tbody> The...
20. ### to sum the data match in two files by using Vlookup

Hi all.. i have two excel files which are data and master..both files will be use for salary calculating.. the vlookup formula will be use in master files for dragging the salary data from Data files..the formula as follow VLOOKUP(B4:B225,'D:\Salary\[Data.xls]AUG'!A\$1:F\$65536,6,FALSE)) the...