summed

  1. M

    Working backwards to find initial starting value

    Hello forum, I have a question that I'm unable to correctly search for a solution since I'm unable to word it correctly for a search. Initially I had been looking at some kind of reverse CAGR solution, but what I found wasn't related to my problem. What I'm trying to do is take a Year End...
  2. C

    Sum row cells based on previous cell value

    In my cells for example: Cell A1 A2 A3 A4 A5 A6....etc B 5 D 7 B 3 In the example above cells A1 & A2 go together such as if the value in A1 = B then I need the value in A2 which is 5. I need the value of the cells where the previous cell/cells = B In the example above, A1...
  3. J

    Pivot Table Help- Showing both Percentage and Total as Sum

    I feel like there is an easy built in solution, but I am struggling with this. I would like to show the values as a percentage of the row total, and the grad total for each row as the actual summed value (not 100%). Below is a screen shot of what I get with no calculation, and with "Show...
  4. G

    Matrix SUMIF

    Hi, What formula would be best for a "3D" style SUMIF, to allow a matrix of values to be summed, as in the example below (sorry I can't get the image function to work, so it's a link instead). https://imgur.com/13Pda1w James.
  5. P

    SUMIFS, Multiple columns to sum, multiple criteria

    Greetings, Board. Long time, no see. I need some assistance with a SUMIFS formula, and/or changing the function I'm using. Data is fairly straightforward, but across multiple columns. Col A = date, Col P = $Dollar Amount I need to sum, Col Q = String name I need to match (ie Sale-Auction)...
  6. M

    SUM Variable Range / Column

    Hi all, I am currently struggling with writing a macro, where I would like the macro to sum the last column, starting from the 2nd till the last row of that column. The column which needs to be summed up (last column), can start from Column G, but is variable. This means the column could also...
  7. M

    Index Match to Sum full row

    Hi all, I'm trying to build (what I thought to be a simple) Excel formula that matches a line item from one sheet with another line item from a second sheet and sums up all values in that matched row. This formula needs to be flexible to accommodate new columns so I was hoping to use a mix of...
  8. S

    so I'm trying to sum by ticker and rank largest to smallest (not sure how to do it with same ticker for different lots/amounts)

    I have data in two columns such as: AA 50 AA 30 bb 19 XX 20 XX 10 I'm trying to sum by column A inputs and rank highest to lowest by the summed numbers using column B values
  9. H

    failure to calculate correctly

    formulas fail to sum correctly. I have googled and checked all suggestions found to no avail. I suspect it is due to a mix of text vs. numbers within formulas that create the numbers to be summed. here is one of the formulas: =IF(AND($B63="u",$C63="w"),IF(V63="rns",1.25,IF(V63="c",0,0)),"")...
  10. I

    generating random integers that are correlated and summed to equal a given value

    Hello. I am a novice at excel and have spent more time than I'd like to admit searching for a solution to my question. I want to create a fake dataset for two variables and I alos want to calculate Chronbach's alpha (i.e., reliability score) of those items. I need this information because I will...
  11. D

    How to combine values from multiple rows into a single row in Excel

    I have found a post that similar what I need to be done, but I do not know how to convert it to fit my purposes and data. I am not sure if I can link it here but ( How to combine values from multiple rows into a single row in Excel? - Super User ). What is different is that I am wanting to sum...
  12. S

    merge duplicates and sum certain totals

    <tbody> A B C D E F DESCRIPTION STOCK# PO REORDER# QTY SOLD TY QTY SOLD LY QTY SOLD TO DATE AA 1 FC1 6 3 18 AA 1 FC1 5 2 25 AA 1 FC1 1 5 63 BB 2 33 10 2 33 BB 2 33 5 5 18 BB 2 33 3 3 21 CC 3 15 6 9 19...

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