Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct ?? Question
My data comes in like this:
Type ID Group B BOX017 VR A BOX017 S1 B BOX017 S1 A BOX234 S1 B BOX017 S1 B BOX017 GK I am trying to find a formula for cell B2 below that will count the number of occurances of Type=A, ID=BOX017, and Group=S1. ID Type A BOX017 1 Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct ?? Question
=SUMPRODUCT(--(A2:A7]=""A""),--(B2:B7]=""BOX017""),--(C2:C7]=""S1""))
HTH -- AP "carl" a écrit dans le message de ... My data comes in like this: Type ID Group B BOX017 VR A BOX017 S1 B BOX017 S1 A BOX234 S1 B BOX017 S1 B BOX017 GK I am trying to find a formula for cell B2 below that will count the number of occurances of Type=A, ID=BOX017, and Group=S1. ID Type A BOX017 1 Thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct ?? Question
Whats up with the square bracked and the double double quotes?
=SUMPRODUCT(--(A2:A7="A"),--(B2:B7="BOX017"),--(C2:C7="S1")) -- Regards, Tom Ogilvy "Ardus Petus" wrote: =SUMPRODUCT(--(A2:A7]=""A""),--(B2:B7]=""BOX017""),--(C2:C7]=""S1"")) HTH -- AP "carl" a écrit dans le message de ... My data comes in like this: Type ID Group B BOX017 VR A BOX017 S1 B BOX017 S1 A BOX234 S1 B BOX017 S1 B BOX017 GK I am trying to find a formula for cell B2 below that will count the number of occurances of Type=A, ID=BOX017, and Group=S1. ID Type A BOX017 1 Thank you in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct ?? Question
If you need to make several searches and
you want to save typing, enter this formula below Countx: =SUMPRODUCT((Type=TypeX R)*(ID=IDx R)*(Group=GroupX R)) Formula is in R1C1 style. Arrange your search data this way and name it: TypeX IDx GroupX Countx A BOX017 S1 1 B BOX017 S1 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Question | Excel Worksheet Functions | |||
another sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question | Excel Discussion (Misc queries) | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |