software

I am using Excell to extract and interigate information provided to me in a
spreadsheet format of fire rescue related incidents to allow me to identify
trends etc.

The spreadsheet consists of headed columns.
What I am trying to do is excell to look in different columns for a criteria
and then tell me how many entries match the criter.

For exmple Column Q may be a list of areas within the county, Column K may
be a list of incident types, m- a list of causes, j types of property and P
may be numbered category that the property type belongs.

What I need it to do is count how many rows match a criteria such as
Dwelling fires (identified as quot;-1quot; in P), Fire listed in column K, of
suspicious origin - Column M, in the area of Surrey Heath (listed in column Q)

I would very much appriciate any help anyone can offer
--
pk

I'd probably do this with a PIVOT TABLE.
Go to MVPS.org and do a search for PIVOT Tables. I'd do it, but I need to
restart my computer to do it right now.

quot;PKquot; gt; wrote in message
...
gt;I am using Excell to extract and interigate information provided to me in a
gt; spreadsheet format of fire rescue related incidents to allow me to
gt; identify
gt; trends etc.
gt;
gt; The spreadsheet consists of headed columns.
gt; What I am trying to do is excell to look in different columns for a
gt; criteria
gt; and then tell me how many entries match the criter.
gt;
gt; For exmple Column Q may be a list of areas within the county, Column K may
gt; be a list of incident types, m- a list of causes, j types of property and
gt; P
gt; may be numbered category that the property type belongs.
gt;
gt; What I need it to do is count how many rows match a criteria such as
gt; Dwelling fires (identified as quot;-1quot; in P), Fire listed in column K, of
gt; suspicious origin - Column M, in the area of Surrey Heath (listed in
gt; column Q)
gt;
gt; I would very much appriciate any help anyone can offer
gt; --
gt; pk
You can use the sumproduct formula to count (or total) multiple conditions;
check www.xldynamic.com/source/xld.SUMPRODUCT.html
You might also look at the DCOUNT function.

quot;PKquot; wrote:

gt; I am using Excell to extract and interigate information provided to me in a
gt; spreadsheet format of fire rescue related incidents to allow me to identify
gt; trends etc.
gt;
gt; The spreadsheet consists of headed columns.
gt; What I am trying to do is excell to look in different columns for a criteria
gt; and then tell me how many entries match the criter.
gt;
gt; For exmple Column Q may be a list of areas within the county, Column K may
gt; be a list of incident types, m- a list of causes, j types of property and P
gt; may be numbered category that the property type belongs.
gt;
gt; What I need it to do is count how many rows match a criteria such as
gt; Dwelling fires (identified as quot;-1quot; in P), Fire listed in column K, of
gt; suspicious origin - Column M, in the area of Surrey Heath (listed in column Q)
gt;
gt; I would very much appriciate any help anyone can offer
gt; --
gt; pk

I would suggest using the AutoFilter. Highlight all of the column headings
you want to be able to sort by. Then select quot;Dataquot; from the menu bar and
then quot;Filterquot; then quot;AutoFilterquot;.

Now, you should see dropdown arrows in each of your column headers. Simply
select the criteria for each column.

If you need a formula to count the displayed number of columns, you can use
this:

=SUBTOTAL(102,A:A)

I'd suggest putting it in Row 1 after all of your headers so that it never
gets filtered with the rest of your data.

HTH,
Elkarquot;PKquot; wrote:

gt; I am using Excell to extract and interigate information provided to me in a
gt; spreadsheet format of fire rescue related incidents to allow me to identify
gt; trends etc.
gt;
gt; The spreadsheet consists of headed columns.
gt; What I am trying to do is excell to look in different columns for a criteria
gt; and then tell me how many entries match the criter.
gt;
gt; For exmple Column Q may be a list of areas within the county, Column K may
gt; be a list of incident types, m- a list of causes, j types of property and P
gt; may be numbered category that the property type belongs.
gt;
gt; What I need it to do is count how many rows match a criteria such as
gt; Dwelling fires (identified as quot;-1quot; in P), Fire listed in column K, of
gt; suspicious origin - Column M, in the area of Surrey Heath (listed in column Q)
gt;
gt; I would very much appriciate any help anyone can offer
gt; --
gt; pk

Google Search: pivot.table site:mvps.org
might be a good way to start given all the sites that reproduce
newsgroup postings, but once you find your way to 10 (soon to be 11) links at
www.mvps.org/dmcritchie/excel...tm#pivottables
I think you are going to end up at:

the index page at Contextures.com
www.contextures.com/tiptech.html

and to a Flash (Macromedia) presentation for an overview at
www.datapigtechnologies.com/ExcelMain.htm

Surprise there is more than one Flash presentation, but between
those two sites it would be hard to find better general information
on Pivot Tables.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Barb Reinhardtquot; gt; wrote in message ...
gt; I'd probably do this with a PIVOT TABLE.
gt; Go to MVPS.org and do a search for PIVOT Tables. I'd do it, but I need to
gt; restart my computer to do it right now.
gt;
gt; quot;PKquot; gt; wrote in message
gt; ...
gt; gt;I am using Excell to extract and interigate information provided to me in a
gt; gt; spreadsheet format of fire rescue related incidents to allow me to
gt; gt; identify
gt; gt; trends etc.
gt; gt;
gt; gt; The spreadsheet consists of headed columns.
gt; gt; What I am trying to do is excell to look in different columns for a
gt; gt; criteria
gt; gt; and then tell me how many entries match the criter.
gt; gt;
gt; gt; For exmple Column Q may be a list of areas within the county, Column K may
gt; gt; be a list of incident types, m- a list of causes, j types of property and
gt; gt; P
gt; gt; may be numbered category that the property type belongs.
gt; gt;
gt; gt; What I need it to do is count how many rows match a criteria such as
gt; gt; Dwelling fires (identified as quot;-1quot; in P), Fire listed in column K, of
gt; gt; suspicious origin - Column M, in the area of Surrey Heath (listed in
gt; gt; column Q)
gt; gt;
gt; gt; I would very much appriciate any help anyone can offer
gt; gt; --
gt; gt; pk
gt;
gt;