Formula help

[Donna Middleton]

I am very inexperienced with excel formulas and I'm trying to create a
formula for a worksheet. I have 2 columns of information from row 3 to row
88. In column b I have different kinds of repairs like chair, floor crack,
ceiling crack, etc. In the column next to the repair I have a number (how
many of that kind of repairs). I want to add the numbers together for each
kind of repair for a total at the bottom. Can anyone help? Thanks- Donna

 

[Jason Morin]

A pivot table would be the quickest way. But you could
also do this:

1. Create a list of all the types of possible repairs
found in column B. Put them in, say, F1:F10.
2. In G1, insert this formula, and copy it down:
=SUMIF($B$3:$B$88,F1,$C$3:$C$88)

Now if the total in G1:G10 does not equal the total
repairs, you've either left out a type of repair in your
list or misspelled one of them.

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

Instead of worksheet functions, I'd recommend you create a Pivot Table -
your application is ideal for PTs. While they can be made to be complex,
they're not inherently so.

See Help and

http://peltiertech.com/Excel/Pivots/pivottables.htm

for assistance in creating a PT.