Hi!

Floor type range = C2:C100
Sq. Footage range = D2:D100

=SUMIF(C2:C100,"cement",D2:D100)

Better if you use a cell to hold the criteria:

A1 = cement

=SUMIF(C2:C100,A1,D2:D100)

Biff

"sip8316" <sip8316@discussions.microsoft.com> wrote in message
news:030C41CD-B864-4DED-958F-C67F8F5A2175@microsoft.com...
>I have a spread sheet that has data on buldings set up in such a way that
>the
> rows are different room types and the columns are Floor Type and Sq.
> Footage. At the bottom of the sheet I have a row that gives total square
> footage for each floor type of all the rooms combined.
>
> Right now I am using the Sum() function but I have to go through and
> individually select sq footages for the respective floor type. For
> example
> if 3 rooms have a cement floor I look down the sq footage column and sum
> the
> ones that have "cement" in the floor type column, and same with capret,
> etc.
> respectively.
>
> Is there a way to use an if statement or anything else so that excel
> automatically searches for a certain floor type and only adds the square
> footage for those and puts that value in a cell.
>
> Help if you can.