164102/group-by-sum-in-excel

Let's assume that I have the following table in Excel

A B Item quantity_sold A 3 A 4 A 1 B 5 B 2 D 12 C 3 C 7 C 8

and I need to sum up quantity_sold grouped by Item and print the results on the adjacent column only once per group, similar to the following

A B C Item quantity_sold SUM_by_item_type A 3 8 A 4 A 1 B 5 7 B 2 D 12 12 C 3 18 C 7 C 8

Is there any way I can achieve this without using Pivot Tables?

It is very easy and you can do it with a simple formula

if u select the next column for rearranging the data and type the formula =IF(A2=A1,"",SUMIF(A:A,A2,B:B))

Here A2 is a relative cell you want to sum based on, A1,A is the column you want to sum based on the B column you want to sum the values

This statement is used with the aggregate ...READ MORE

I'm just not sure how a SQL ...READ MORE

This statement is used to sort the ...READ MORE

From the version 5.1.7 onward, MySQL allows ...READ MORE

The times are probably preserved as text. SUM ...READ MORE

More grouping levels have been added to ...READ MORE

Here is a flimsy answer. The number ...READ MORE

You can use SUMPRODUCT for this. Assuming X is in cell B1, ...READ MORE

B1 formula is: =SUMIF(A1:A5,"<=5") +COUNTIF(A1:A5,">5") *5 Fill in the blanks ...READ MORE

Basically for this, you need to create ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.