Which one is the correct average value for Click Through Rate (CTR)?

Occasional Visitor


CTR is defined as Clicks / Impressions. I want to calculate average CTR of the given data. If I use Average function on CTR it gives me average of 0.16%. If I use Total Clicks / Total Impressions I get average of 0.21%. Which one should I consider as the correct one?

1 Reply


The second one =SUM(B2:B8)/SUM(A2:A8).