From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas

Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas

“

- [Instructor] On this worksheet, 2 we're seeing a table in columns A through G. 3 It's about 900 rows. It covers a two year period. 4 The table name is called Sales. 5 We're going to be using that table name in formulas 6 and we'll be using four different functions. 7 You'll see them off to the right in the yellow box, 8 UNIQUE, TRANSPOSE, SUMIF and SUMIFS. 9 And what we're trying to create 10 is what we're seeing in this blue box in the lower right. 11 If you've not worked with formulas and tables, 12 sometimes it can be a little confusing, 13 a little awkward, 14 but much of what we do here has a huge advantage 15 because the data's a table 16 and the advantage is if the list grows or shrinks, 17 we don't have to worry about rewriting our formulas. 18 So in cell J2, 19 let's come up with a unique list initially 20 of all of our different products here, =unique, 21 and we will be referring to that table, 22 I…

Contents