If statement

[eramirez148]

How can I make column D to create the percent difference of each date for the total of column c for each item in column 1. I need a formula to automate this.

	Column A	Column B	Column C	Column D
Row 1	Item 1	8/1/2024​	10​	9%​
Row 2	Item 1	8/2/2024​	20​	18%​
Row 3	Item 1	8/3/2024​	30​	27%​
Row 4	Item 1	8/4/2024​	50​	45%​
Row 5	Item 2	8/5/2024​	90​	34%​
Row 6	Item 2	8/6/2024​	82​	31%​
Row 7	Item 2	8/7/2024​	56​	21%​
Row 8	Item 2	8/8/2024​	25​	9%​
Row 9	Item 2	8/9/2024​	9​	3%​
Row 10	Item 2	8/10/2024​	5​	2%​
Row 11	Item 3	8/11/2024​	7​	35%​
Row 12	Item 3	8/12/2024​	2​	10%​
Row 13	Item 3	8/13/2024​	9​	45%​
Row 14	Item 3	8/14/2024​	2​	10%​

 

[hagia_sofia]

Do you mean this:

=C1/SUMIFS($C$1:$C$14;$A$1:$A$14;A1)

 

[eramirez148]

Doesn't seem like the formula is working

 

[hagia_sofia]

Yup, apologies, forgot to replace semicolons - try this:

=C1/SUMIFS($C$1:$C$14,$A$1:$A$14,A1)

 

[xlhelp15]

How about this?

=C2/SUMIFS(C$2:C$15,A$2:A$15,A2)

=C3/SUMIFS(C$2:C$15,A$2:A$15,A3)

=C4/SUMIFS(C$2:C$15,A$2:A$15,A4)

=C5/SUMIFS(C$2:C$15,A$2:A$15,A5)

=C6/SUMIFS(C$2:C$15,A$2:A$15,A6)

=C7/SUMIFS(C$2:C$15,A$2:A$15,A7)

=C8/SUMIFS(C$2:C$15,A$2:A$15,A8)

=C9/SUMIFS(C$2:C$15,A$2:A$15,A9)

=C10/SUMIFS(C$2:C$15,A$2:A$15,A10)

=C11/SUMIFS(C$2:C$15,A$2:A$15,A11)

=C12/SUMIFS(C$2:C$15,A$2:A$15,A12)

=C13/SUMIFS(C$2:C$15,A$2:A$15,A13)

=C14/SUMIFS(C$2:C$15,A$2:A$15,A14)

=C15/SUMIFS(C$2:C$15,A$2:A$15,A15)