conditional formulas

[Aaargh]

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!!

 

[Ragdyer]

So, what are all your codes for single family houses?

Are there 5 or 10 ... OR ... 20 or 50 ... or what?

 

[JMB]

Assuming your data was in A1:C3 and you want to sum by use code in column B,
perhaps
=SUM(SUMIF(B1:B3,{110,113},A1:A3))

or if you want to sum the entries that have "SF RES" in column C, then try:
=SUMIF(C1:C3,"SF RES",A1:A3)

both of which return 1.9 for the sample data you gave.


If you must have column C populated, I would probably set up a table (let's
say in Sheet3!A1:C3 - and there are different ways of doing it that may be
more efficient, depending on what all of your use codes look like). If the
use codes are text in your data, input them as text in the table:

110 SF RES
113 SF RES
4000 SF RES


Then in cell C1 of your data sheet
=VLOOKUP(B1,Sheet3!$A$1:$B$3,2,0)

and copy down. Then use the Sumif above that uses "SF RES" - or you could
sort the table and subtotal it.