Article View: comp.sys.mac
Article #16963Help needed with text + Excel
From: brucec
Date: Mon, 22 Jun 1987 04:34
Date: Mon, 22 Jun 1987 04:34
28 lines
1460 bytes
1460 bytes
Hi, I am using Excel on the Mac & I am having problems with using
text instead of numbers.
I have a list of items & numbers that are either S(mall), M(medium) of L(arge)
and either N(ew) , O(ld) or blank for not there.
As a sample I would have:
1 S N
2 S O
3 M
4 S N
5 L N
I would like to be able to calculate the number of OLD: S,M,L and New S,M,L.
I tried to use the function "=IF($B1="S",IF($C1="O",1)) on each line (on
$D, for example) and sumed up all of the 1's in $D but I doubled the
amount of data needed (I had similar functions in the $E, $F, $G columns).
Q: Is there an easy (or hard) way to match up 2 numeric fields and add up
the number of matches?????? Do I need to write a macro?
Any leads will be greatly appreciated.
--
|{seismo,harvard}!uwvax!astroatc!brucec "A person is only as big as the
|{ihnp4,decvax}!nicmad!astroatc!brucec things that make him angry."
Technical Details
Message-ID:
<336@astroatc.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!clyde!rutgers!uwvax!astroatc!brucecShow Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!clyde!rutgers!uwvax!astroatc!brucec From: brucec@astroatc.UUCP Newsgroups: comp.sys.mac Subject: Help needed with text + Excel Message-ID: <336@astroatc.UUCP> Date: Mon, 22-Jun-87 00:34:51 EDT Article-I.D.: astroatc.336 Posted: Mon Jun 22 00:34:51 1987 Date-Received: Tue, 23-Jun-87 03:40:42 EDT Reply-To: brucec@astroatc.UUCP (Bruce Cantrall) Distribution: na Organization: Astronautics Technology Cntr, Madison, WI Lines: 28