Formula: Counting Cells on Different Worksheets
 

I have 1 spreadsheet. This spreadsheet consists of 4 worksheets total.

Worksheet 1 – Summary

Worksheet 2 - High

Worksheet 3 - Medium

Worksheet 4 - Low

Worksheets 2 through 4 consist of three columns each, they a

Column A Column B Column C

Username Reason Feedback

For every entry made on Worksheets 2 thru 4, I’d like it to automatically count those entries made and note the figures on the Summary's worksheet in column B. The Summary worksheet looks like this:

**************************************
Column A Column B

High 22

Medium 10

Low 4
***************************************

Hi,

Have a look at the attached. Is this what you mean?

The formulas on the Summary tab count the number of Usernames entered in the other three tabs. For it to work accurately it is therefore important that every row entered has a username. If there is no username, the row will not be counted and the numbers will be wrong.

Hope that helps.

S.

Spence,

That looks great! We are definitely on the right track. I think what is presently throwing it off is that fact that I have several HEADERs and a SUB-HEADERs in Column A, therefore the count is being skewed. I've attached a exampe format of what I'm describing. Hopefully that will help explain things better.

I'm trying to think of a simple way of excluding those so need more info...

Are there a fixed number of headers and sub-headers or could this change over time?

Do the headers and sub headers conform to any sort of fixed pattern?

Each primary header is a category. There are four categories on each worksheet. i.e. "High", "Medium", "Low"

The primary header and sub-header are fixed and would not change and conform to a fix pattern.

Any chance you could post an example workbook so I can see exactly how it's laid out. Would make it far easier to provide a viable solution.

Hi Spence,

Here you go. Here is the spreadsheet I'm working on in it's exact format. Hope this helps.