subtotals

  • Thread starter Thread starter DumbCluck
  • Start date Start date
D

DumbCluck

I would like to create a macro (or vba function) that subtotals by user
then by type. I have two fields that I would like to total, amount and
reimbursement amount.
I would like the macro to sort and subtotal on type and then provide a grand
total
by user.
I have three different types (P, C & R).
I tried using the sort and subtotal functions in excel (2003) but have not
had any
success. Can someone please point me in the right direction?
kind regards,
 
Since you provide little info, If I understand you don't need to subtotal.
Try this idea

=sumproduct((a2:a22="P")*(b2:b22="username")*c2:c22)
 

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

Summing Subtotals 4
Average of Subtotals in Pivot Table 0
subtotal function 1
Sorting subtotaled amounts in excel 2
Sorting subtotal results 5
Calculating subtotals 22
subtotals 5
Subtotaling variable data in a macro 1

Back
Top