This website or its third-party tools use cookies which are necessary to its functioning and required to improve your experience. By clicking the consent button, you agree to allow the site to use, collect and/or store cookies.
The platform this site runs on doesn't have the option to turn off cookies server side, but you can do that in your browser and then return to the site.
I accept
Deny cookies Go Back

Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Sep 12 2014

How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]

Function tag teaming at its finest
We have some serious tag teaming going on with this data

In today’s #FunctionFriday post we’re going to look at how the SUMIF and SUMIFS functions can be used to build out interactive dashboards like the ones below I just added to my dashboard course for subscribers to apply to their data.

Excel dashboard for analytics data
Click for larger image

 

Excel dashboards for Google Analytics
Click for larger image

Note: If you want to reanimate the images, just refresh the page with a hard refresh. On a PC use Ctrl-F5 and Command-Shift-R if you’re on a Mac. (I hate animated gifs that automate ad infinitum.)

Excel File Download

I don’t share the whole dashboard, but I share a portion, so you can see how I used both the SUMIF and SUMIFS functions in a single formula to make the drop-down at the top of the dashboard update the entire dashboard.

Here is what the formula looks like that you’ll be learning to rock. Call it a formula BOGO deal. 🙂 Example of SUMIFS dashboard in Excel Members of the Annielytics Dashboard Course will have full access to the dashboard, as well as directions for how to update it with your analytics data. Or you could buy it for $795 and have my team update it with your data and colors/branding. It would require a subscription to Analytics Canvas, which you can get for $49/mo for one user. Having tried most of the API tools for Google Analytics, I found Analytics Canvas to have, by far, the most flexibility, especially if you’ve screwed up your campaign tagging. (It allows you to rewrite this data.)

You can download the Excel file to follow along.

Video

Warning: I have a habit of saying formula when I mean function. Formulas are made up of individual functions, such as the SUMIF and SUMIFS functions.

Written by Annie Cushing · Categorized: Excel · Tagged: Excel Dashboards, Excel Formulas, Google Analytics, Google Analytics API, Interactive Charts

Comments

  1. Dacey says

    October 29, 2014 at 7:52 AM

    Great post
    Thanks a lot really you taught me awesome excel formulas

    Reply
    • Annie Cushing says

      November 28, 2014 at 11:49 PM

      Wonderful! Happy to help. 🙂

      Reply
  2. DEANCE says

    May 16, 2017 at 11:21 AM

    VERY GOOD …..I NEED YOU HELP

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2023 annielytics.com