I have been receiving Value errors on this so I hope I can find some type of solution on here. I tried the index/match route but I don't think it works when you have multiple rows that you are trying to add up.
1st: In sheet 2 I am trying to find all of A2 on that sheet with sheet1 and get the sum that have a "YES" on column L. If Column L says "NO" it needs to be omitted. (Which will be "SUM OF ORDER")
2nd: for SUM OF BUDGET (Column C in sheet 2) I am trying to add up all of the ones that have a "YES" on Column L as well
I hope this makes sense! I have attached the workbook.
Thank you!
Bookmarks