View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Subtotal withouth subtotaling

You don't give enough detail and layout. So, google for
sumproduct:excel

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rrodriguezdiaz30" wrote in
message ...
I would like to know if there is a formula that would return subtotals from
a
table. Let me explain. I have a payroll report with names of employees,
dates of payments, deductions etc. I would not want to change the order
of
the table as it is updated with every week's payroll. But I'd like to
generate a report from it that'd give me year to date information, per
employee. Hope I'm not complicating my life too much?

Thanks
--
Roberto