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
|