Excel SUMIF and COUNTIF in Tableau

By: Eric Parker

Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can also sign up for a Tableau Office Hour to work with him directly!

Need help with your Tableau calculations? Sign up for an office hour to work with Eric! Want to dive deep into Tableau? Check out our upcoming Tableau classes!

So you are making the jump from Excel to Tableau? Great!

You've probably noticed some of the functions you love so much in Excel don't exist in exactly the same format in Tableau. Take SUMIF and COUNTIF as an example. Tableau has an IF function, a SUM function and a COUNT function, but not SUMIF or COUNTIF.

Not to worry though! All the functionality of those Excel functions can be replicated in Tableau if you know how to work the system! :)

Check out this video to learn how you can use the IF, SUM and COUNT functions to accomplish SUMIF and COUNTIF things in Tableau!

You can download the Tableau Public Workbook here.

Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss out on new blog posts, videos and events!

How to Expand and Contract a Text Table in a Tableau Dashboard

How to Concatenate Text Values in Tableau

0