Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help quickly!!
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help quickly!!
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help quickly!!
You can use SUMPRODUCT. =SUMPRODUCT((A1:A100="MA")*(B1:B100)) Where A is your list of abbreviations and B are your numbers to sum. Rather than type the abbreviation in the formula, you could have a drop down list with all state abbreviations and have your formula refer to that cell say C1. Then you could just select a state abbreviation from the list and the formula would return the value for that abbreviation. =SUMPRODUCT((A1:A100=C1)*(B1:B100)) Does that help, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=517306 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help quickly!!
=SUMIF(A1:B5,C1,B1:B5) A1:B5 is the range C1 is the Crieteria B1:B5 adds up the numbers that meet the criteria -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=517306 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding small units of time and entering them quickly | Excel Discussion (Misc queries) | |||
How can i quickly mark a huge range, like A1 to DV3500? | Excel Discussion (Misc queries) | |||
How do I quickly fill a formula result into a column of cells? | Excel Worksheet Functions | |||
How do I make a column of checkboxes quickly? | Excel Discussion (Misc queries) | |||
Add a baseline **kind of trend** to a Excel graph quickly | Charts and Charting in Excel |