|
|
 |
| found 67 articles for 0.303 sec |
  |
Group: nl.architectuur · Group Profile · Search for Basketbally in nl.architectuur
Author: mirapeeters
Date: Aug 15, 2008 07:16
Mail received on spamtrap. This spamtrap mail has been redacted, the mail was not really sent to <Glennie-1037@users.spamikaze.org>. URLs have been stripped of the parts before and after the host name. From b.vos@lifeleadership.nl Tue Jul 08 09:14:14 2008 Return-path: <b.vos@lifeleadership.nl> Received: from [77.94.249.26] (helo=net3-nl-smtp-02.vevida.net) by shelob.surriel.com with esmtp
|
| Show full article (3.73Kb) |
| =SUM(IF(IF(ISNUMBER(FIND("(",A1:A10)),LEFT(A1:A10,FIND("(",A1:A10)-2),A1:A10)="Knicks",B1:B10))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
Note that you cannot use a whole column in |
|
 |
|
 |
Group: news.admin.netabuse.sightings · Group Profile · Search for Basketbally in news.admin.netabuse.sightings
Author: Andrzej Filip
Date: May 23, 2008 09:30
Personally, I would use Data TextToColumns to separate the teams out into their own columns....then a regular SUMIF would work......and you could use another SUMIF to figure their "away" points as well......... Vaya con Dios, Chuck, CABGx3 "Mark" wrote: I am trying to write a program to collect scores of basketbal games. Here is what I have. Column A is the team and where
|
| Show full article (8.35Kb) |
|
|
|
1 ·
2 ·
3 ·
4 ·
5 ·
6 ·
7 ·
next |
|
|
