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