Use SUMIF in a Pivot Table to Get Sum Based on Range of Term

[papgar]

This is not easy to explain in the title. I have a set of data in a worksheet that is some 1,500 rows. I am trying to get the sum of all contracts (LRIFCT) based on the range of the term of the contract (LRCVMN) by each dealer (LRDLR). I am assuming SUMIF would work in the pivot but I cannot see how to put any other formulas in the pivot other than what is in the drop down dialog box for the standard formulas. I am attaching a sample workbook which can show you what I am trying to accomplish. Any help would be greatly appreciated.

[ashishmehra2010]

Hi,

Please check the attached file.

Regards,
AM

[papgar]

ashishmehra2010, thank you I did finally figure this one out.

[ashishmehra2010]

Hi Papgar,

Thanks for the reputation.

Pivot Tables are initially look a bit tough but as you spend more time on Pivots; you can easily get the outcome without using formulas.

Glad it worked for you. Welcome back any time!

Please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved.

Regards,
AM