LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Data based upon a condition Chris Excel Worksheet Functions 2 April 8th 10 06:19 PM
Summing rows based upon condition Tom Excel Discussion (Misc queries) 2 February 7th 10 06:39 PM
excel summing N largest values by condition [email protected] Excel Discussion (Misc queries) 5 November 23rd 07 02:08 PM
summing up values in a column based on values in 3 other columns Axel Excel Programming 4 March 30th 07 10:40 PM
Summing an array based on text condition RestlessAde Excel Discussion (Misc queries) 3 April 21st 05 05:44 PM


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"