openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wade Smart <wadesm...@gmail.com>
Subject Question about sumproduct
Date Mon, 19 Aug 2013 00:38:39 GMT
I want to use sumproduct to tell me how many
games I have scheduled for a certain team.

=SUMPRODUCT(S152:S191="Green",V152:V191="2:00 PM")

Here is a typical line:
Nov 17, Green, vs, Lt Blue, 2:00 PM

The time when you click on it actually says 02:00:00 PM.

Ive tried different variations of how to write 2:00 but my result
is always "0".

Ive used this function when counting certain player types:
=SUMPRODUCT($AK$2:$AK$101="Dk Blue", $AE$2:$AE$101="Yes")
tells me how many goalies I have per team.

Is this a problem with time?
Wade


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message