Forum Discussion
Group by in excel
I have multiple values for each date of Jan. month and i need total of values for each date how can i go about this is there any other option than writing power query?
vedantaher Use a pivot table!
I did thing is i want to multiply type1 and type2 and then do the sum for that date but pivot is giving me sum of Type1 and sum of type 2 which is not desirable
Date Type1 Type2 result 01-08-2023 z y 01-08-2023 a g 02-08-2023 b hPerhaps you can use SUMPRODUCT
=SUMPRODUCT(--(DateColumn=Date), Type1Column, Type2Column)
vedantaher Sorry, I don't understand.
my input
Date type1 type2 01-08-2023 2 3 01-08-2023 1 2pivot output and my result accordingly
Date type1 type2 Result 01-08-2023 3 5 15what i want
Date Result 01-08-2023 8
