Forum Discussion
Solved
Sum of Total Paid for each ID
Hello I'm trying to calculate Total paid amount 6m prior and 6m after initial based on the Paid, 6m prior to initial and 6m post initial columns. Please see below. Please advise a formula Tha...
I would put these sums elsewhere on the spreadsheet, since you are basically (in the case of your examples at any rate), displaying two rows on the input end of things but expecting one row at the output.
This is the formula I used (which does require Excel 2021 or newer).
=SUM(FILTER(Table1[Paid],(Table1[ID]=J2)*(Table1[6m prior to Initial]=1),0))
Below is an image of the sheet, and I've attached the actual spreadsheet.
Hi mathetes Thank you for sharing I'm using Excel version 2016. Is it possible to modify? Please let me know thank you