| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count across multiple worksheets?
In column A is the client or a day off
in column I is the employee (RD) there are 31 worksheets I want to count how many days off RD has had. or how many jobs for silverdell he has done by changing the criteria cell. I've tried various other counts/if and sum attempts but I always get #ref My last attempt was =SUMPRODUCT(('1:31'!A9:A15="SILVERDELL")*('1:31'!I 9:I15="RD")) but it changes it to =SUMPRODUCT(('1:[31]31'!A9:A15="SILVERDELL")*('1:[31]31'!I9:I15="RD")) Suggestions please Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count unique email addresses across multiple worksheets? | Excel Discussion (Misc queries) | |||
| Count Text within Multiple Worksheets | Excel Worksheet Functions | |||
| count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
| Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Count # of times value "x" appear across multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
