Sum multiple occurences in a table

**DavidL1981** · 08-10-2019, 11:00 AM

I am trying to make a formula to sum total tips by "Role" on this table. I am having a lot of trouble. I want for formila to return all tips for Role "Server - 35th Floor" Any suggestions?

Capture.PNG

**MarvinP** · 08-10-2019, 11:17 AM

Hi David and welcome to the forum,

This is an easy Pivot Table problem. No formulas needed.

Here is a 45 second course on how to do this.

https://support.office.com/en-us/art...9-F99134456576

Sum multiple occurences in a table

LinkBack

Thread Tools

Rate This Thread

Display

Sum multiple occurences in a table

Re: Sum multiple occurences in a table

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table help! add values instead of count occurences

Populating a table with number of occurences of a particular text

[SOLVED] Table to pick out most common entries and count occurences of each

Table to pick out most common entries and count occurences of each

Table to pick out most common entries and count occurences of each

Table to pick out most common entries and count occurences of each

[SOLVED] Table to pick out most common entries and count occurences of each

[SOLVED] Table to pick out most common entries and count occurences of each

Bookmarks

Bookmarks

Posting Permissions