• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting part of a URL from multiple cells and calculating the bounce rate

P

Pourquoi

New Member
Hello,

I'm trying to find a formula that would give me the average bounce rate for all the pages of the blog session of my website.
I have all the URLs of my website in column A, the associated number of sessions in column B and the associated bounce rate in column C.
Guessing I will need to use sumproduct along with isnumber/len function but I'm not exactly sure how to combine those together.
Thanks in advance !
 
Last edited:
To help solving my issue, I've attached a sample of my data with the different formulas I have used.
Any help would be appreciated
 

Attachments

  • Sample Data - URLs.xlsx
    48.9 KB · Views: 5
Just found the solution, if anyone is interested below:
=SUMPRODUCT(ISNUMBER(SEARCH("company.com/blog",A$2:A$9)),B$2:B$9,C$2:C$9)/SUMIF(A$2:A$9,"*company.com/blog/*",B$2:B$9)
 
You must log in or register to reply here.
Back
Top