Please help with Excel formula!?

Question

I need help writing an excel formula. What I need the formula to do is this: ( I will try to explain this in the clearest way possible! )

I have a spreadsheet that consists of about 100 utility bills for 10 different properties. I need the formula to go through and pull all of the matching properties and total the amount due.

If I remember correctly I think I need to give each property a corresponding number and let excel pick it up that way, but I don't know how to make it add all of the cells.

Answer 1

Why don't you sort the properties in alphabetical order and then just add them that way?

Answer 2

use the PivotTable feature to do it.  It would be a very easy and perfect solution to this problem.  Just click on the PivotTable menu option and the "wizard" will walk you through it.  Using the Pivot Table will let you group all the properties together and sum their bills up.  And it doesn't require you to mess around with your original data.  Check it out...it works great

Answer 3

A formula isn't gonna work.

You can do 1 of 2 things, both which will need you to assign some type of identifier for each property, eg Property ID#.

First way would be to sort the sheet by property ID# and then use subgroups.

The second way is much more involved and requires knowledge of VBA programming where you'd use a loop and 10 variables, one for each property and a Select Case statement. Then you would have totals for all 10 properties and then you can assign the value of the variable to any cell you want.