conditional sum

  1. W

    Finding range of partial match hits

    I have a table containing a column of names in the form (V1a, V1b, V1c, V2, V3a, V4a, always in that sort of order). Next to this column is another containing number values. I want to sum all the values belonging to the same name (V1, V2 or V3). That is, I want to sum the values beside "V1a"...
  2. N

    Sum of Dynamic Range in loop

    Hi, I have a data set that repeats on same tab of excel with certain information for ex. For given range of dates, I want to see what all items had transactions in system and their respective quantities used in months of a year. So, data repeats per item and has quantity values for each month...
  3. S

    Excel 2003 "List" where in 2007?

    In Excel 2003 I'm able to go to Data and then List to create a List which allows me to then use the Conditional Sum function (in Tools) In Excel 2007 - When I open one of my existing worksheets that had a List in it, the List is no longer defined and the Conditional Sum formulas do not...
  4. I

    conditional sum on multiple criteria with only 1st occurance

    Hello, I am trying to find a formula that will conditionally sum a column of data (i.e. a sumif) based on whether the data is associated with (across from) a cell that matches a list of criteria from another tab. I've used a sumproduct formula that i've found elsewhere on another post. The...
  5. O

    Doing the conditional sum of differences between rows

    Hi, I am trying to obtain the sum of the differences between two rows column by column. I have two criteria to choose the column to compare. The first one is to have the word "Rank" in the heading of the column, this seems to work when I look to the calculation step by step. The second...
  6. O

    Sum if a set of values is in a range

    Hi, I am trying to construct a formula that sums values in a range only if the heading of the column is in another range. <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR...
  7. S

    Generating dynamic dropdown list in Excel

    Background information: I am using Excel 2003 on Windows XP. I am trying to get a unique list to create a drop down list. I have a sales report where Col A=Product Name, Col B=Month, Col C=Year, Col D=Total Sale Value. I am using "Conditional Sum" to get the Total Sale amount from Col D...
  8. J

    Sum of first n from m cells

    Hi, Using excel formulas, how do find an sum of first n values of an array? Each cell in the array may or maynot contain a number, ignore non-numbers in an array? If n is greater than count of number then add all numbers present in the array. In each case I would like to find the count of...
  9. H

    Conditional Sum

    Hi, I have a spreadsheet for materials with categories, I want to assign cells for totals for each category. Example: Vidoe --> Category 1 Cassette --> Category 2 Audio ---> Category 3 In column A I have the categories In column B I have the description (video, cassette, audio ..etc) I...
  10. S

    Sum data across sheets - if certain value is selected

    I have a number of identical sheets containing similar data (data in cells E10 through F15. These are all placed within two "limiters" - 'start ->' and '<- end'. On my summation sheet I sum up the data be using '=SUM(start ->:<- end!E10)' in cell E10 (and so on until F15). Now I would like...
  11. K

    Conditional SUMIF statement

    I am having some issues with a conditional SUMIF statement. Here are the details. The statement below currently works. Contents of K14 =IF(J14="Yes",F14,IF(A14<>A13,SUMIF(A:A,A14,F:F),"")) Column A are Dates in chronological order Column F is a $ amount. Column J is "Yes" or blank. If Yes...
  12. C

    Conditional Sum of the Highest N Numbers in a Range

    I'm trying to sum the highest N numbers in a range, conditionaly. Through searching, I found a couple ideas, but couldn't quiet make them work. What I'm trying to do: Column A has a list of names: Johnson Murphy Johnson Fredericks Martin Murphy Column B has a corresponding number: 1 2 3 6 8 1...
  13. T

    URGENT - Compare 2 columns and sum up the corresponding numbers in the third

    Dear Excelites, Please can you help me with this problem in excel...
  14. S

    SumIf the Sum of Unique Values is greater than criteria

    I have a problem which is beyond my capabilities. I need excel to sum amount column (See example table below) by unique values in company column then conditionally sum those values based on the year of investment, stage of company and finally, the kicker, the summed Amount by unique companies...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top