# sum based on criteria

1. ### Matching up a total

Hi all, I can't imagine that my question is original, but I haven't found an answer searching the messages (prolly using the wrong keywords for my problem). Anyway, I have a number, let's say 30 mio, and I have column with all different kinds of values all way smaller than 30 mio, let's say 301...
2. ### Dynamic Sum function with filter

I'm trying to come up with a function that will let me search remaining values, filter them from small to largest, and then sum them based on a count reference in another cell. I can get everything laid out, but i'm not sure how to only sum a range based on another cell value, and exclude...
3. ### Sumifs

hi, I have 4 selected criteria (data validation list): column A1 = Region column C1 = Country column E1 = Owner column G1 = Service. In my data rows region is in column AN, country in column AJ, owner in column AM and service in column AR. <tbody> AN - Region AJ - Country AM - Owner AR...
4. ### Sumproduct Multiple Criteria

I'm trying to use sumproduct to calculate an aggregate figure based on multiple criteria but one array has multiple variables. For example: =sumproduct(data*(cars="honda")*(year=2013)*(model=(standard,deluxe,luxury)) For the model criteria, what do I need to change in the formula to pull the...
5. ### sum in a range of cells that contain letters and numbers

Hello everyone, I need to sum all the numerical values (the numbers before the letter) in column A based on what letter they have. So, the result for "a" would be 3.5, "b" would be 3 etc. (as below in red) Notes and restrictions: The only possible numerical values are :1 or 2 or 0.5. Letters...
6. ### SumifS help in Excel 2013 need help to add a date range.

Hello, I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26...
7. ### Sum of values from unique string criterias [VBA]

Hello I have a very large dataset of unique funds, their sector and size. I have to sum up all the values for each sector in each fund. There are a lot of different string values so I need to use VBA to search for each unique string and add their corresponding together and create the output in...
8. ### Macro - Sum counted rows with specific words from several files

Hi, i need to present a weekly report which would sum the results of validated values in several excel files (excel 2010). It is not the same files every week, however all files are in exactly the same format. The report needs to sum the number of approved, rejected and revised values in the...
9. ### Need to find sequential serial numbers and group them counting # of #

I have serial numbers on the same product that is numbered sequentially. For some reason we have sold individual serial numbers and they are no longer consecutive. I need to be able to find sequential numbers, Label them as consecutive and display how many consecutive numbers are in a group and...
10. ### Get sum of only visible values?

I have a table with autofilter enabled I also have a cell that is supposed to show the sum of values in column C, cell C1 But the things is, the sum formula gets the sum of everything in column C. I only want the formula to add items when it's visible in the table. If I want to know the total...
11. ### VBA - sum cells that match criteria and copy rows to different sheet

I am a complete novice when it comes to VBA (excel 2007) and am looking for some help putting together a macro to help in processing a large number of data rows in a worksheet. I have a worksheet with raw output data from another program. I want to look through the worksheet, sum certain cells...
12. ### Sum a column based on one criteria

Hi Guys, I have been wrecking my head with the following! hope you guys can help? I am trying to look for some VBA Code so that I can search multiple values in Column "A" based on the criteria in Textbox1 and SUM up the corresponding values in Column "B" based of course on the criteria in...
13. ### Summing duration in different formats

Hi! I'm a relative novice on excel but trying to do something fairly complicated with time (as a duration) which has got me completely stumped - would really appreciate any help people could give me. I've copied and pasted my spreadsheet of data to help you see what my issues are. The data is...
14. ### Summing duration in different formats

Hi! I'm a relative novice on excel but trying to do something fairly complicated with time (as a duration) which has got me completely stumped - would really appreciate any help people could give me. I've copied and pasted my spreadsheet of data to help you see what my issues are. The data is...
15. ### Macro To Sum Lines With Same Criteria

I need a macro to "subtotal" the data below. Basically, there are invoices that can have different "Types" of costs on them, however, sometimes the information provided by the billing dept. the types can be repeated. For example, invoice 57 for Kansas has P listed twice, as well as T. I need...
16. ### How do you sum every 5 rows in a column, obtaining the result in the adjacent column?

Hello, I'm working with about 1400 lines in excel: I simply need to sum every 5 rows in a single column, and report the result in the adjacent column. For example, the data I am trying to sum is an column G. I would like to sum G2:G6, G7:G11 etc...and have the result be reported in H1, H2..etc...
17. ### finding the specific sum of values in a given column and then grouping the sum of the values.

Hello All, I need help in finding a formula that will sum up the range of values in a specific column then i need to group the sum of the values by that specific sum. column A has 1200 line items: various names of pencil cases (PCRed, PCBlue, PC Green etc. column B also has 1200 line items...
18. ### how to automatically sum and merge rows based on same value in column?

hello, can anyone help me perform the following calculation in excel please? I have a long list of items and their quantities, example: <tbody> 101001 1 101001 6 101001 2 101001 1 101002 6 101002 1 101003 6 101004 6 101005 6 101050 1 101050 1 101050 5 101050 1 101050...
19. ### Sum help

Hi there once again. Here is what i am trying to do. In column W i have a comment of "BAD" In column D i have a length In column A i have a number What i would like to do is have a formula that will look at column W and find the comment of "BAD", then sum the length of column d between two...
20. ### Formula to count how many times adjacent cells in a row fulfil a certain criteria

Hi, I’m using Excel version 12.1.0 for Mac. I’m having trouble making a formula that will allow me to recognize ‘episodes’ in rows of data. The criteria for an episode is that four or more adjacent cells (adjacent by column) need to have a value of 1,2 or 3. I’d like the formula to count...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...