Pivot Table and Count Number

Hi,

I have a pivot table with a bunch of subject lines used for an email campaign. I also have values for the average open rate of each subject line.

What I need is to see how many times I've used a specific subject line.

So if you take a look at the excel sheet that I've attached, I want to be able to see how many times I've used a specific subject line.

Any ideas on where I can start.

Thanks for your help,

Not sure I understand? do you want a simple COUNT of SUBJECT?

ie.................

80 Million Movies in 5 Minutes 22
80 Million Movies To Download On Your PC 3
80 million movies -Yeah, we know that's a lot 3
Access The Internet's Largest Movie Selection 5
Boredom Be Gone: 80 Million Movies For Your PC 4
Don't Be The Last One Again 18
Download From The Internet's Biggest Movie Library 5
Download HD Movies - Includes DVR Recorder 46
Download Movies Online - New Movies For Your PC 3

Check the attachment.......

I've done it for you.

any questions please ask.

Cheers