-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
$30
-
M
Multiple rollups by different aggregations in same table
I am trying to develop a payment schedule rollup for our expenditures. I have a disconnected table with various payment durations and I want to total the checks that were paid in that time period. <tbody> Duration Jan 018 Feb 2018 etc Immediate $100 $200 1-7 days $300 $40...- macfuller
- Thread
- $30 check days payment vouchers
- Replies: 2
- Forum: Power Tools
-
R
Sum based on multiple criteria in different columns
Hi, I'm trying to sum a list of values if two criteria are met in two different columns. See below for example: <tbody> Invoice ID (Criteria 1) TRUE/FALSE (Criteria 2) Amount 1 True $60 2 False $10 3 True $50 3 False $50 4 False $30 4 True $30 </tbody> What I'm do is come up with...- Rockforce
- Thread
- $30 column criteria false true
- Replies: 7
- Forum: Excel Questions
-
E
Balance from one column added to a cell in the next column help.
Hello all, and as usual, thank you for the help in advance! I want to pay off a list of expenses over a certain number of months using the same amount of money each month. Once one expense is paid off, I want to allocate the money that was going to that expense to the next expense, and so on...- E. Jones
- Thread
- $30 balance expense paid payment
- Replies: 5
- Forum: Excel Questions
