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?
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 h 
Perhaps you can use SUMPRODUCT
=SUMPRODUCT(--(DateColumn=Date), Type1Column, Type2Column)