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. |
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) |