| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting multiple criteria
Thanks,
-- Thanks, Shane Devenshire "ShaneDevenshire" wrote: Hi Peo, A quick question - why use =SUMPRODUCT(--(arealog=A2),--(typelog=B2)) instead of =SUMPRODUCT(N(arealog=A2),N(typelog=B2)) ? -- Thanks, Shane Devenshire "Peo Sjoblom" wrote: =SUMPRODUCT(--(arealog="bending"),--(typelog="sprain")) note that your named ranges need to have the same dimension I would personally use =SUMPRODUCT(--(arealog=A2),--(typelog=B2)) where A2 and B2 are 2 cells where you would put the criteria, that way you don't need to edit the formula itself if/when you change the criteria -- Regards, Peo Sjoblom " wrote in message ... Sorry if this has been covered before but I can't find a solution. I have a workbook logging accidents. I have a range named "arealog" detailing which department the accident occurred in i.e. forge, bending, painting, bushing etc. I also have a range named "typelog" detailing the type of accident i.e. bruise, sprain, laceration etc. On a sperate sheet of the same workbook I want to be able to count the number of "Sprains" in the "Bending" department. something like SUM((arealog=€¯bending€¯)IF(typelog=€¯sprain€¯ )) Hope this makes sense Thanks in anticipation Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Multiple Criteria | Excel Worksheet Functions | |||
| counting with multiple criteria | Excel Worksheet Functions | |||
| Counting by multiple criteria | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
