View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] annysjunkmail@tiscali.co.uk is offline
external usenet poster
 
Posts: 48
Default Grouping and summing values based on a condition?

I have 2 worksheets called TotalPyts & Customers

Sample data on wsheet TotalPyts looks like this:

ID PytType Amt
1 Credit 68020.3
1 Payment 28381.68
1 Credit 1936.04
1 Payment 8753.39
1 Credit 16701.31
2 Payment 45277.56
2 Payment 24287.05
2 Payment 6823.91
2 Credit 26372.1

I am trying to calculate the sum of type of payments on wsheet
Customers so it looks like the following:

ID TotalCreditAmt TotalPaymentAmount
1 86657.65 37135.07
2 26372.1 76388.52


I have tried to use a SUMIF statement but it doesn't allow me to add
the 'condition' as explained above.
I do not want to do this by pivot table (my colleague find these
difficult to interpret) so wish to use a worksheet function if
possible.

Grateful for help

Chris