software

ok...let's see if I can explain the problem...
Column F has manually entered numbers 1, 2, or 3. (They're codes for
reasons behind variances. They could also be called X, Y, or Z.)
I need Cell C71 to tell me how many 1's (or X's) are in Column F
Cell C72 should tell me how many 2's (or Y's) are in Column F
Cell C73 should tell me how many 3's (or Z's) are in Column F

I tried the standard =DSUM formula for the respective cells (C71, C72,
amp; C73), but i just get the -#VALUE!- error.

Any advice?
If more info is needed, I can provide it. (Just thought I should leave
the posting as uncluttered as possible)

thanks, mike--
miketv------------------------------------------------------------------------
miketv's Profile: www.excelforum.com/member.php...oamp;userid=30934
View this thread: www.excelforum.com/showthread...hreadid=506074Use the COUNTIF function. E.g.,

=COUNTIF(F:F,1)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;miketvquot; gt;
wrote in message
...
gt;
gt; ok...let's see if I can explain the problem...
gt; Column F has manually entered numbers 1, 2, or 3. (They're
gt; codes for
gt; reasons behind variances. They could also be called X, Y, or
gt; Z.)
gt; I need Cell C71 to tell me how many 1's (or X's) are in Column
gt; F
gt; Cell C72 should tell me how many 2's (or Y's) are in Column F
gt; Cell C73 should tell me how many 3's (or Z's) are in Column F
gt;
gt; I tried the standard =DSUM formula for the respective cells
gt; (C71, C72,
gt; amp; C73), but i just get the -#VALUE!- error.
gt;
gt; Any advice?
gt; If more info is needed, I can provide it. (Just thought I
gt; should leave
gt; the posting as uncluttered as possible)
gt;
gt; thanks, mike
gt;
gt;
gt; --
gt; miketv
gt;
gt;
gt; ------------------------------------------------------------------------
gt; miketv's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30934
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=506074
gt;
Hi!

Are you saying that column F contains either the numbers 1,2,3 and/or the
letters X,Y,Z ?

1 and X should be counted as the same
2 and Y should be counted as the same
3 and Z should be counted as the same

If that's the case enter this formula in C71 and copy down to C73:

=COUNTIF(F$1:F$100,ROWS($1:1)) SUMPRODUCT(--(CODE(UPPER(F$1:F$100amp;0))=ROWS($1:88)))

Biff

quot;miketvquot; gt; wrote in
message ...
gt;
gt; ok...let's see if I can explain the problem...
gt; Column F has manually entered numbers 1, 2, or 3. (They're codes for
gt; reasons behind variances. They could also be called X, Y, or Z.)
gt; I need Cell C71 to tell me how many 1's (or X's) are in Column F
gt; Cell C72 should tell me how many 2's (or Y's) are in Column F
gt; Cell C73 should tell me how many 3's (or Z's) are in Column F
gt;
gt; I tried the standard =DSUM formula for the respective cells (C71, C72,
gt; amp; C73), but i just get the -#VALUE!- error.
gt;
gt; Any advice?
gt; If more info is needed, I can provide it. (Just thought I should leave
gt; the posting as uncluttered as possible)
gt;
gt; thanks, mike
gt;
gt;
gt; --
gt; miketv
gt;
gt;
gt; ------------------------------------------------------------------------
gt; miketv's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30934
gt; View this thread: www.excelforum.com/showthread...hreadid=506074
gt;

Chip Pearson Wrote:
gt; Use the COUNTIF function. E.g.,
gt;
gt; =COUNTIF(F:F,1)
gt;
*******************************
Man! How easy was that!? thanks a mil!--
miketv------------------------------------------------------------------------
miketv's Profile: www.excelforum.com/member.php...oamp;userid=30934
View this thread: www.excelforum.com/showthread...hreadid=506074