Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing Columns Based On Value
I have a spreasheet with 150 rows of entries. In the 8th column I have
different options that can be in it, i.e. Database, FOIA, Consulting Events and Rent. These 150 rows are not sorted on the 8th coulmn no can they be. I would like a cell at the bottom of the worksheet that sums eac group. The user needs up to the second data and doesn't have time t resort and re SUM the fileds. I don't even know where to begin. An help would be fantastic -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing Columns Based On Value
=Sumif(H1:H150,"Database",I1:I150)
the range cited in the 3rd argument contains the values to be summed. The first argument is where the condition is checked. If you mean you want to count how many rows are labelled database =Countif(H1:H150,"Database") -- Regards, Tom Ogilvy "stck2mlon " wrote in message ... I have a spreasheet with 150 rows of entries. In the 8th column I have 5 different options that can be in it, i.e. Database, FOIA, Consulting, Events and Rent. These 150 rows are not sorted on the 8th coulmn nor can they be. I would like a cell at the bottom of the worksheet that sums each group. The user needs up to the second data and doesn't have time to resort and re SUM the fileds. I don't even know where to begin. Any help would be fantastic. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing 2 columns based on variables | Excel Worksheet Functions | |||
Summing one column based on criteria from two other columns | Excel Worksheet Functions | |||
Summing cells based on mulitiple criteria over mulitple columns | Excel Discussion (Misc queries) | |||
Summing based off different columns | Excel Worksheet Functions | |||
Summing specific Columns based on Criteria | Excel Discussion (Misc queries) |