Sumifs

[scargo]

Okay let me see if I can explain this...I am looking to match

Supplier Name #sheet 1 to Supplier Name #3

If those two suppliers match,then look for the Known Spend, If Known Spend is equal to "Y", then look to see if the they fall within two columns with dates. Now if that all information matches, then output an invoice $ amount

Columns sets

Invoice $
Known Spend
Supplier Name 1
Supplier Name 2
Start Date
End Date

Please help

 

[Special-K99]

There is no "Supplier Name #3 "

There is "Supplier Name 1" and "Supplier name 2" but not a 3.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Make sure your data and formulas are clearly defined.

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.