Help! Need help finding a way to combine these two formulas.

[tylernol]

Hi,

Basically, I am trying to combine both of these formulas. The first counts every row that contains these 3 words. The second provides a count of every date that fits within the past 14 days. Both formulas work perfectly separately but I can't figure out how to combine them to find a count of every instance of these 3 words together within the past 14 days.

=SUMPRODUCT((Combined!B:B="EVS")*(Combined!K:K="Pending")*(Combined!D:D="External"))

=SUMPRODUCT((I8:I106<=TODAY())*(I8:I106>=TODAY()-14))

Any solution or work around would be appreciated!

[#2]

@tylernol 

Perhaps this:

=SUMPRODUCT((Combined!B8:B106="EVS")*(Combined!D8:D106="External")*(Combined!K8:K106="Pending")*(Combined!I8:I106<=TODAY())*(Combined!I8:I106>=TODAY()-14))

[#3]

I don't why it wasn't working for me originally, but you did it! Thanks!!!

[#4]

You're welcome! Glad it worked.