As an example

=SUMPRODUCT(--(A1:A1000="value1),--(B1:B1000=17))

this will count all the items in column A that match value1, and where the
corresponding value in column B is 17. If you want to add up a further
value, then

=SUMPRODUCT(--(A1:A1000="value1),--(B1:B1000=17),C1:C1000)

--
HTH

Bob Phillips

"SMKDonde" wrote in message
...
I didn't have any room to type anymore when I entered it. Here's the
deal.
I have a file with monthly worksheets that contain several columns of
information. Basically what I want to do is take several of the columns
(1
at a time) and perform functions such as sum; countif; avg; etc. based on
certain criteria in a column (ie: new or used; salesperson; model; etc.).
I
know that excel can do this ... I've just never done any programming and I
need to learn how. Thanks for any input you can give.


"David" wrote:

Hi,
I think you will have to be a little more specific.

"SMKDonde" wrote:

I have monthly worksheets containing several columns of information.
I would
like to perform different functions and calculation