Thread: Ecxel Subtotal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
esutton@wilberforce edu esutton@wilberforce edu is offline
external usenet poster
 
Posts: 1
Default Ecxel Subtotal

I have used a spreadsheet from the payroll office and compiled subtotal for
each. example:
pp1 50
pp2 50
pp3 40
total 140
My problem is that the total are listed on differnet rows and i need to
reference them to the amounts i have on another spread sheet to compare all
the totals. How can i do so without having all the pp1, pp2, or pp3
displaying at the same time