Should be simple I thought

LDLValentine

I have tried what I thought should be a simple formula two or three different ways. Here is the basis of the requirement.

Multiple Months, Multiple Vendors with multiple invoices within a month, Multiple projects that some of the vendors bill to and others do not.

For the purpose of this exercise, I need to get the invoice total by month and vendor. I am able to do this in the summary for the Invoice Sheet, but for some reason cannot bring the same logic into the Budget / Forecast Sheet.

There are two sheets involved one is the Invoice Sheet where the "Invoice Total", "Vendor ID", and "Svc Month" are located. The other sheet is the Budget sheet where Month over Month Total by Vendor should be, which includes "Vendor ID", and columns for each month, e.g., "Aug 2023"

any assistance would be very much appreciated at this point as I am now at a loss.

Paul Newcome

Try removing a closing parenthesis from the formula above.

Paul Newcome

Try removing a closing parenthesis from the formula above.

LDLValentine

Paul, thank you. I knew I had been looking at this thing too long. Worked perfectly.

Paul Newcome

Happy to help. 👍️