ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
My worksheet has data with column labels.
Column C - Principal
Column G - Interest
Column F - Reason
(Column F rows may contain "Machine Purchase", "On Account", or "Cash Advance" - each appears repeatedly in the column.)
=SUMIFS(G2:G131,F2:F131,"Machine Purchase",C2:C131,">75000") gives the correct result of 48,024
Is there a way to extract this result in a pivot table? I dragged the Reason field in the Rows area so there is a list of the three possible entries in column F. Is it possible to extract the total interest for each of the three, but only for the rows in the data set in Column C are > 75,000?
Thanks!
Column C - Principal
Column G - Interest
Column F - Reason
(Column F rows may contain "Machine Purchase", "On Account", or "Cash Advance" - each appears repeatedly in the column.)
=SUMIFS(G2:G131,F2:F131,"Machine Purchase",C2:C131,">75000") gives the correct result of 48,024
Is there a way to extract this result in a pivot table? I dragged the Reason field in the Rows area so there is a list of the three possible entries in column F. Is it possible to extract the total interest for each of the three, but only for the rows in the data set in Column C are > 75,000?
Thanks!