Formula: Counting Cells on Different Worksheets

[itsmevic]

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 are:

Column A Column B Column C

Username Reason Feedback

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

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

High 22

Medium 10

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

 

[Spencer101]

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 t
automatically count those entries made and note the figures on th
Summary's worksheet in column B. The Summary worksheet looks lik
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 i
the other three tabs. For it to work accurately it is therefor
important that every row entered has a username. If there is n
username, the row will not be counted and the numbers will be wrong.

Hope that helps.

S

+-------------------------------------------------------------------
|Filename: itsmevic example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=433
+-------------------------------------------------------------------

 

[itsmevic]

Hi,

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

The formulas on the Summary tab count the number of Usernames entered i
the other three tabs. For it to work accurately it is therefor
important that every row entered has a username. If there is n
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 thin
what is presently throwing it off is that fact that I have severa
HEADERs and a SUB-HEADERs in Column A, therefore the count is bein
skewed. I've attached a exampe format of what I'm describing.
Hopefully that will help explain things better

+-------------------------------------------------------------------
|Filename: Example.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=435
+-------------------------------------------------------------------

 

[itsmevic]

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

Are there a fixed number of headers and sub-headers or could this chang
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 eac
worksheet. i.e. "High", "Medium", "Low"

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------