Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 *************************************** |
#2
|
|||
|
|||
Quote:
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. |
#3
|
|||
|
|||
Quote:
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. |
#4
|
|||
|
|||
Quote:
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? |
#5
|
|||
|
|||
Quote:
The primary header and sub-header are fixed and would not change and conform to a fix pattern. |
#6
|
|||
|
|||
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.
|
#7
|
|||
|
|||
Quote:
Here you go. Here is the spreadsheet I'm working on in it's exact format. Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for counting cells with value 'x' provided Col U = 'y' | Excel Worksheet Functions | |||
Counting blank cells in a formula | Excel Worksheet Functions | |||
Subtotal counting formula in cells | Excel Discussion (Misc queries) | |||
Formula for counting number of cells | Excel Discussion (Misc queries) | |||
Counting cells with formula CF (not value CF) | Excel Worksheet Functions |