Subtotal withouth subtotaling

  • Thread starter Thread starter rrodriguezdiaz30
  • Start date Start date
R

rrodriguezdiaz30

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
 
You don't give enough detail and layout. So, google for
sumproduct:excel
 
Hi,

You can use the SUMIF funtion:

=SUMIF(A$1:A$100,M1,B$1:B$100)

Where A1:A100 contains the employee, B1:B100 contains the payment and M1
contains the employee you want to sum for. Enter all the employees in
M1:M10 for example and copy the formula down.

If this helps, please click the Yes button.

Cheer,
Shane Devenshire
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grand total subtotals without hiding details 7
Average of Subtotals in Pivot Table 0
Subtotal sorting 2
What is fomula for entering dates that are 7 days apart? 1
Subtotal =0 2
subtotal, match? 10
Creating a summary list of larger dataset 1
Formula to sum based on a change in another column 2

Back
Top