sum based on criteria

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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