Formula help

  • Thread starter Thread starter Donna Middleton
  • Start date Start date
D

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
 
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
 
Back
Top