LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default conditional formulas

I've done all the searches online and off for help. Now time's running out
for my project. Here's the situation...

My data is in two columns with thousands of rows, columns are Parcel Size in
Acres (number) and Use Code (numeric text). There are probably a couple
hundred different use codes. I would rather group the more detailed use
codes into broader categories, then get those total acreages.

For example, there are several use codes that specify exactly what type of
single-family house but all I really need to know is that it is a
single-family house. Ultimately, I need the total acreage of the parcels
that contain a single family house.

I've tried populating a third column based on use code...no luck. I've
tried various sumif or dsum versions. I've not a mathematically oriented
person so most of these formulas are like greek to me.

Here's an example of the data setup:
A B C?
Parcel Acres Use Code Potential Column?
0.4 110 SF RES
1.5 113 SF RES
2.7 4000 Vacant Commercial
etc etc


Any help very humbly appreciated!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formulas Nick Excel Discussion (Misc queries) 4 April 1st 06 07:18 AM
How do I set up conditional formulas craig Excel Worksheet Functions 1 February 4th 06 09:45 PM
Conditional Formulas Norm75 Excel Discussion (Misc queries) 2 December 23rd 05 07:42 PM
conditional formulas Paul Sheats Excel Worksheet Functions 2 October 3rd 05 08:31 PM
conditional formulas deaundra Excel Worksheet Functions 3 April 15th 05 12:44 AM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"