Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Countif results
My heads hurting trying to sort this one out, and the answer will be so
obvious...but can anyone clear this up for me I need to record multiple results based on set criteria being met i.e the total number of Criteria A's for Staff Group B, Criteria A's for Staff Group A and so on. Staff Group A Criteria A Staff Group B Criteria A Staff Group A Criteria A Staff Group B Criteria B Staff Group B Criteria B I've tried =SUMPRODUCT(--(Sheet1!B:B="Staff Group A")*(Sheet1!C:C="Criteria A")) but keep getting #Num Can anyone help FtB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Multiple COUNTIF formula | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
CountIF across multiple sheets in a workbook | Excel Worksheet Functions |