to sum or not to sum, cute huh?

[mrxwantobe]

So I have column B with some membership numbers. There are some dups. for example 110 is listed 8 times. In column C is some dollar amounts I need to total. Will sumif add the dollar totals in C if the member number in column B matches?

 

[CWatts]

You're welcome. Pivot tables are quite powerful and, in my opinion, best learned by trial and error. Now that you have the basic presmise down, you'll find you can do a lot with them. Have fun!