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: [email protected] For additional commands, e-mail: [email protected]
