Hi Dean, You can probably use SUMPRODUCT, but if you could attach your spreadsheet, or a sample thereof, it'd be easier. Regards - Dave.> Date: Mon, 17 Nov 2008 18:14:14 -0800> Subject: $$Excel-Macros$$ counting values> From: [EMAIL PROTECTED]> To: excel-macros@googlegroups.com> > > I have a list of building data. Within that data, there are 15 unique> towns. I want to know how many times a building of a certain age group> occurs in each town. There are 13 age groups. For example:> > Los Angeles - 1930 = 34,000> Santa Barbara - 1910 = 670> > I have tried COUNTIF and other formulas, as well as advanced> filtering, and I have not been able to find the right thing to help> me. Can anyone offer any assistance?> > Thanks in advance,> Dean> > _________________________________________________________________ Time for change? Find your ideal job with SEEK. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Atl%3Ask%3Anine%3A0%3Ahottag%3Achange&_t=757263783&_r=SEEK_tagline&_m=EXT --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
