Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Would love some help with this challenge. Accident data is being recoded in a spreadsheet and has info recorded for 12 month. In a separate tab I want to count the number of instances by a given month, then by a given department, and then by accident type. Have used three separate "countif" statements and can get the number of accidents for a month, the total number for a give department for 12 months, and the total number by accident type for 12 months. I want to be able to get the total for a month, by department, then accident type. Hope someone can help me, thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count data that meets more than one criteria? | Excel Discussion (Misc queries) | |||
Counting unique text that meets several criteria | Excel Worksheet Functions | |||
SUM data if meets criteria | Charts and Charting in Excel | |||
Show only data that meets a certain criteria | Excel Discussion (Misc queries) | |||
Averaging data that meets a criteria | Excel Worksheet Functions |