Simple formula

[rawr19911]

I am just brain dead after the whole new years, I need a formula that will count Column A together for everything that is the same in column B.

Example so i would want all of the records with ABC to be added together so 170 for abc.com and 90 for DEF.com to show up in total hit counts for each. Thank you

HitCount	URL	Total hit counts
50	abc.com
30	abc.com
60	abc.com
50	def.com
20	def.com
30	abc.com
20	def.com

 

[Scott Huish]

You want a Pivot Table.

 

[Joe4]

A SUMIF formula would give you your desired results too, i.e.

Formula in cell C2, copied down:

=SUMIF($B$2:$B$8,B2,$A$2:$A$8)

 

[rawr19911]

A SUMIF formula would give you your desired results too, i.e.

View attachment 120897

Formula in cell C2, copied down:

=SUMIF($B$2:$B$8,B2,$A$2:$A$8)

thanks

 

[Joe4]

You are welcome.
Glad we could help!