Hi

I would suggest using Data / Pivot Table as this is designed to summarise
information.
There is an intro to using this powerful tool he
http://peltiertech.com/Excel/Pivots/pivottables.htm

Hope this helps.
Andy.

"alexm999" wrote in
message ...

I have a spreadsheet that has in column I a state abreviation. (NE, MA,
etc...). In column G I have a number of subscribers. I'd like a report
formula that adds up all the numbers associated with a specific state.

I'm doing it manually now and it's a pain! help!


--
alexm999
------------------------------------------------------------------------
alexm999's Profile:
http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=517306