Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
I have monthly worksheets containing several columns of information. I would
like to perform different functions and calculation |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
namely?
-- HTH Bob Phillips "SMKDonde" wrote in message ... I have monthly worksheets containing several columns of information. I would like to perform different functions and calculation |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
specific example of something I need to do is as follows: Two different
columns are labeled as such ... column A (Type), column E (make). One calculation I want to set to do automatically is if the type (column A) is N (new) then perform the function countif on column E. "Bob Phillips" wrote: namely? -- HTH Bob Phillips "SMKDonde" wrote in message ... I have monthly worksheets containing several columns of information. I would like to perform different functions and calculation |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
SMK -
Your description is *still* rather ambiguous & vague, but nothing that you've described sounds as though it needs VBA. Sounds more as though you need to look into Pivot Tables for the data. "SMKDonde" wrote: 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I perform a function based on certain criteria?
As an example
=COUNTIF(A1:A1000,"N) no need for E -- HTH Bob Phillips "SMKDonde" wrote in message ... specific example of something I need to do is as follows: Two different columns are labeled as such ... column A (Type), column E (make). One calculation I want to set to do automatically is if the type (column A) is N (new) then perform the function countif on column E. "Bob Phillips" wrote: namely? -- HTH Bob Phillips "SMKDonde" wrote in message ... I have monthly worksheets containing several columns of information. I would like to perform different functions and calculation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to perform lookups based on multiple criteria? | Excel Worksheet Functions | |||
Lookup function based on 3 criteria | Excel Discussion (Misc queries) | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
Function - counting based on criteria | Excel Worksheet Functions | |||
Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions |