It's a good thing. I been carrying your weight! (Hee hee...RIGHT!!)
"Ken Wright" wrote in message
...
LOL - Thanks Anne :-)

Just glad to be back online again - Had a few machine problems last couple
of weeks, coupled with a new job and a rather hectic calendar in June.
Pretty much kept me out of here for a little while now, but hopefully all
back to normal real soon.

Hope all is well with you.

Regards
Ken.......................


"Anne Troy" wrote in message
news:5b8d3$42d948f0$97c5108d$15560@allthenewsgroup s.com...
Ah. My favorite Excel MVP. :)
*******************
~Anne Troy

www.OfficeArticles.com


"Ken Wright" wrote in message
...
Lookup the following functions:-

COUNTIF which will count the number of whatever variable you ask it to,
within whatever range you define.

SUMIF which will sum values associated with whatever variables you
define

SUMPRODUCT which will do what SUMIF will but will allow multiple
criteria
to
be set.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


------------------------------*------------------------------*-----------
-
----
It's easier to beg forgiveness than ask permission :-)

------------------------------*------------------------------*-----------
-
----






"john mcmichael" wrote in
message
...
I would like to get Excel to add together a list of variables mostly x
,
y
and z and tell me how many of each I have...can I do this and how?

Thanks