View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alexz Alexz is offline
external usenet poster
 
Posts: 2
Default 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