Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT or COUNTIF
I need to count the number of occurrences a number greater than zero apepars
under the "pts" heading; can't do anythiing about the formatting (as there are actually two more sets of Mode/Pts/Date columns. This is for a commute tracking log (for a regular work week-five days). Mode Pts Date Mode Pts Date Mode Pts Date PB 2 R 2 R 2 V 1 W 3 R 2 W 3 X 0 HV 1 B 3 W 3 X 0 C 1 W 3 B 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct vs countif | Excel Worksheet Functions | |||
SumProduct & Countif? | Excel Worksheet Functions | |||
Countif and Sumproduct | Excel Worksheet Functions | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
sumproduct vs. countif | Excel Discussion (Misc queries) |