Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif - Sumproduct
I need to extract data by searching for a numerical value in one column then
a text value from another column. It is a personnel table with ranks listed as numerical values then gender as m or f. I need to know how many of each rank by each gender. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT or COUNTIF | Excel Worksheet Functions | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
Sumproduct or countif? | Excel Discussion (Misc queries) | |||
SUMPRODUCT/COUNTIF | Excel Discussion (Misc queries) | |||
sumproduct vs. countif | Excel Discussion (Misc queries) |