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,
& 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: http://www.excelforum.com/member.php...o&userid=30934
View this thread: http://www.excelforum.com/showthread...hreadid=506074