I'm looking for a formula that will do this

Add up all values (in Col A) that have a match (in Col C) to a word
that I hold in SheetB A1, that in addition have a match (in Col B)
that falls between two dates I hold in SheetB A1 & B1

What I'm trying to do is total all Sales Invoices for certain named
customers for each of a 4 week period. My data is in one sheet,
database format, my parameters in SheetB.

Don't wish to use a Pivot Table

Thanks