summed

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

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

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

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.

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

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

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

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

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)),"")...

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

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

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