Simple formula

rawr19911

Board Regular
Joined
Jan 21, 2020
Messages
93
Office Version
  1. 2016
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

HitCountURLTotal hit counts
50abc.com
30abc.com
60abc.com
50def.com
20def.com
30abc.com
20def.com
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
A SUMIF formula would give you your desired results too, i.e.

1735930543659.png


Formula in cell C2, copied down:
Excel Formula:
=SUMIF($B$2:$B$8,B2,$A$2:$A$8)
 
Upvote 0
Solution
You are welcome.
Glad we could help!
 
Upvote 0

Forum statistics

Threads
1,226,460
Messages
6,191,164
Members
453,643
Latest member
adamb83

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top