Hi, I am making a CF projection, & I need to sum numbers depending on a range or criterias:
Name of Vendor; Payment Status (Paid, Unpaid). That I can do using Sumifs. However, I need to sum up numbers provided that transaction relates only to month which have passed. For ex, I am making CF for the month of May and I only need to sum up unpaid amounts for Vendor 1 if they were to be paid before May (ie Jan, Feb, Mar, Apr). How to add that criteria to SUMIFS or any other formula?
Solved by C. E. in 14 mins