| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting from one column by specific identifier
Say I have two columns, Dog Breeds and Male/Female. In Dog Breeds there are
25 different types, in Male/Female I have either M or F. The actual problem is alot more difficult than this, but I'm trying to simplify the issue to get the result I want. I want to enter a formula that says IF column Dog Breed equals "German Shepherd" Count Males to get a total of Male German Shepherds. Can anyone give me some help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting from one column by specific identifier
On Dec 4, 7:53 pm, Mike wrote:
Say I have two columns, Dog Breeds and Male/Female. In Dog Breeds there are 25 different types, in Male/Female I have either M or F. The actual problem is alot more difficult than this, but I'm trying to simplify the issue to get the result I want. I want to enter a formula that says IF column Dog Breed equals "German Shepherd" Count Males to get a total of Male German Shepherds. Can anyone give me some help? You could try something like =SUMPRODUCT(--(A1:A10="German Shepherd"),--(B1:B10="Male")). Also, have a look at pivot tables. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting from one column by specific identifier
=SUMPRODUCT(--(A2:A200="German Shepherd"),--(B2:B200="Male"))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike" wrote in message ... Say I have two columns, Dog Breeds and Male/Female. In Dog Breeds there are 25 different types, in Male/Female I have either M or F. The actual problem is alot more difficult than this, but I'm trying to simplify the issue to get the result I want. I want to enter a formula that says IF column Dog Breed equals "German Shepherd" Count Males to get a total of Male German Shepherds. Can anyone give me some help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting records in a column range occuring between specific dates | New Users to Excel | |||
| Counting a specific range of values within a column | Excel Discussion (Misc queries) | |||
| VBA column identifier and looping | Excel Programming | |||
| counting only specific numbers in column | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Linear Mode
