can i get excel to add variables

J

john mcmichael

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
 
A

Anne Troy

I think we need a little more information, John. Variable is a VBA word, but
you posted in the worksheet functions, so I'm not sure that's what you mean.
Could you provide an example of exactly what you want to do?
*******************
~Anne Troy

www.OfficeArticles.com
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
K

Ken Wright

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.......................
 
Top