Formula Creation/Formula Help

[yessir]

Is there a formula that could total Freq number found in column B but only when the values in column A are the same?

A	B	C	D
Location	Freq	Freq	Level
AAA	1		Grew
AAA	1		Grew
AAA		1	Shrunk
BBB	1		Grew
BBB		1	Shrunk
BBB	1		Grew
CCC	1		Grew
CCC		1	Shrunk
CCC	1		Grew
CCC	1		Grew
CCC	1	1	No Change

Attached is an example of what the formula would output.

A	B	C	D	E
Location	Freq	Freq	Level	Level Increase
AAA	1		Grew
AAA	1		Grew
AAA		1	Shrunk	2​
BBB	1		Grew
BBB		1	Shrunk
BBB	1		Grew	2​
CCC	1		Grew
CCC		1	Shrunk
CCC	1		Grew
CCC	1		Grew
CCC	1	1	No Change	4​

 

[Fluff]

How about
=IF(A2=A3,"",COUNTIFS($B$2:$B$12,"<>",$A$2:$A$12,A2))

 

[yessir]

Hi @Fluff it worked perfectly! Thanks. If I wanted to Add together what was in column B with the same constraints would I use the same formula but use SUMIFS instead of COUNTIFS? An example of what It would look like is listed below.

A	B	B	D	E	F	G	H
Location	Freq	Totals	Freq		Level	Level Increase	Totals Combined
AAA	1	1,000​			Grew
AAA	1	4,000​			Grew
AAA		2,000​	1		Shrunk	2​	7,000​
BBB	1	1,000​			Grew
BBB		1,500​	1		Shrunk
BBB	1	1,000​			Grew	2​	3,500​
CCC	1	1,000​			Grew
CCC		1,000​	1		Shrunk
CCC	1	1,000​			Grew
CCC	1	1,000​			Grew
CCC	1	1,000​	1		No Change	4​	5,000​

Thanks so much for your help!

 

[Fluff]

would I use the same formula but use SUMIFS instead of COUNTIFS?

That's right, yes.

 

[yessir]

I tried using SUMIFS but I keep getting the error message of "you've entered too few arguments" is there something I'm missing? Thanks!

 

[Fluff]

What is your formula?

 

[yessir]

I am trying to put the totals in column H

A	B	B	D	E	F	G	H
Location	Freq	Totals	Freq		Level	Level Increase	Totals Combined
AAA	1​	1,000			Grew
AAA	1​	4,000			Grew
AAA		2,000	1​		Shrunk	2
BBB	1​	1,000			Grew
BBB		1,500	1​		Shrunk
BBB	1​	1,000			Grew	2
CCC	1​	1,000			Grew
CCC		1,000	1​		Shrunk
CCC	1​	1,000			Grew
CCC	1​	1,000			Grew
CCC	1​	1,000	1​		No Change	4

=IF(A3=A4,"",COUNTIFS($C$3:$C$13,"<>",$A$3:$A$13,A3))

This is the formula I'm using where the "A" in the first row is in cell A1 and the "B" in row 1 is in cell B1 etc... Thanks!

 

[Fluff]

What is the formula after you tried to change it?

 

[yessir]

=IF(A3=A4,"",SUMIFS($C$3:$C$13,"<>",$A$3:$A$13,A3))

 

[Fluff]

Ok, you need to remove "<>"
=IF(A3=A4,"",SUMIFS($C$3:$C$13,$A$3:$A$13,A3))