SUM menu option in Data menu gone

  • Thread starter Thread starter P
  • Start date Start date
P

P

I am using MS XP and I can't find the SUM option. It used
to appear in the Data menu under filter, and allowed me to
highlight an entire spreadsheet and calculate the sum of
items according to the definition in the column of my
choice. For example, my spreadsheet lists web site usage
by institutions for each section of the site. I would use
SUM to sort by institution and total each institution's
usage all at once, rather than having to type in
calculations for each institution.
Can someone please help? Contact me at (e-mail address removed) if
this explanation is confusing or you need more data.

Thanks!
 
Sounds to me like you're looking for Subtotals, which is still there
under the Data menu. If it's not, you can use Tools/Customize,
select the worksheet menu item in the toolbars tab and click Reset.
 
Thanks... That's exactly what I was looking for. It had
disappeared from my menu, but I was able to get it back
with your directions.
 
Back
Top