counting total occurences of a value in a set range of cells across multiple sheets

**MilsonHQ** · 03-29-2016, 01:27 PM

So lets say I have a column that is x number of rows in length max and I need to check the contents of each cell and count all the distinct values, then do this for the same exact cell range over multiple sheets and on a separate sheet I would like to display a list of all the distinct values and how many times each occurred.

What is this called, what type of formula would I need to use, is this some kind of frequency calculation or a countif type deal or what?

Any help would be appreciated.

Thanks

I have added a test workbook containing example data, it is the column of data labeled as Other on each sheet that I would like to do the counting and list of distinct values and how many of each appear etc.

**dflak** · 03-30-2016, 11:46 AM

I cannot download the workbook. It sounds like what you are looking for is a 3-D formula. See this article: https://support.office.com/en-us/art...2-787d0bc888b6.

**MilsonHQ** · 03-30-2016, 01:55 PM

Yeah not sure why you cannot download the workbook.

Basically in a simplistic fashion

If for example Column L cells 1 through 20 have various different text values entered, I need to be able to count how many times each different value is there.

So lets say I have the text Google in 3 of the cells, the text WM in 5 of the cells, the text UR in 6 cells and in 4 other cells it says Facebook

Then this would be on 5 different sheets in that workbook (with different text on each sheet, sometimes no text sometimes every cell)

I need to be able to firstly compile a list of all the different text being used in the cells

For example.

Facebook

Google

UR

WM

Then this list would be created and displayed in a column on a separate sheet, in the column next to it would be the values of how many times that text appears

So using the above example values from just one sheet I would end up with.

Facebook	4
Google	3
UR	6
WM	5

counting total occurences of a value in a set range of cells across multiple sheets

LinkBack

Thread Tools

Rate This Thread

Display

counting total occurences of a value in a set range of cells across multiple sheets

Re: counting total occurences of a value in a set range of cells across multiple sheets

Re: counting total occurences of a value in a set range of cells across multiple sheets

Thread Information

Users Browsing this Thread

Similar Threads

Counting all occurences of one number over multiple sheets.

evaluate range of dates for total same month occurences

Counting number of occurences specific date in range of cells in a table

Counting Occurences W/in Specific Date Range

Counting Unique Occurences in a Range

counting occurences in data range (e.g 31-60)

counting occurences from multiple ranges

Counting occurences of a substring in a range of cells.

Bookmarks

Bookmarks

Posting Permissions