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
|