View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stck2mlon[_22_] stck2mlon[_22_] is offline
external usenet poster
 
Posts: 1
Default 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