Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Countif
Good morning, nothing can ever be easy in the Army. ;-)
I have a workbook with multiple worksheets. The First sheet contains totals etc. I want to be able to count all occurences of data in different tabs and return those values to specific locations on the first sheet. Example. I have SGT Jones, SGT Smith and SGT Adams. Each of these have specific mission numbers that I need to track for each month. I want to track,for example, how many times each of them acquires a bolt and how many times each acquires a nut for each month. So I have OCT, NOV, DEC sheets along with the MAIN sheet in the workbook. On the main Sheet I have each of the Soldiers names in Column A and I want to tally the number of bots and nuts for each month in the columns to the right. I have tried multiple times to do a countif, but I can't get it to work right. I can provide a sample of the workook if necessary. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Advanced use of IF | Excel Worksheet Functions | |||
Advanced COUNTIF Function | Excel Worksheet Functions | |||
Excel 2000 - Advanced IF AND ELSE COUNTIF?? | Excel Worksheet Functions |