Forum Discussion
Alexandra1910
Oct 16, 2023Copper Contributor
Help please
Hello. I need help with building a sumifs formula. I have a very large data sheet full of invoices and payment due dates. I need to build a formula which would sum the amounts due, based on the ...
- Oct 16, 2023
Alexandra1910 But you can format a pt to display in tabular report lay-out and without subtotals. done that in the attached file. Wouldn't that work?
Riny_van_Eekelen
Oct 16, 2023Platinum Contributor
Did you consider using a pivot table? Some examples in the attached file.
Alexandra1910
Oct 16, 2023Copper Contributor
Hello. Yes ofc I did but that doesn't help me. I need to have this data in more row. Using pivot table doesn't help 😞 I have 2000 invoice references that I need to compress according to the due date and invoice reference and they need to be in one row, as a normal table ...
- Riny_van_EekelenOct 16, 2023Platinum Contributor
Alexandra1910 But you can format a pt to display in tabular report lay-out and without subtotals. done that in the attached file. Wouldn't that work?
- Alexandra1910Oct 16, 2023Copper ContributorThat would 100% work thanks a lot! I tried with the pivot table but couldn't figure it out. Thanks again 🙂