Forum Discussion
tylernol
Mar 13, 2023Copper Contributor
Help! Need help finding a way to combine these two formulas.
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!
3 Replies
Sort By
- Patrick2788Silver Contributor
Perhaps this:
=SUMPRODUCT((Combined!B8:B106="EVS")*(Combined!D8:D106="External")*(Combined!K8:K106="Pending")*(Combined!I8:I106<=TODAY())*(Combined!I8:I106>=TODAY()-14))
- tylernolCopper ContributorI don't why it wasn't working for me originally, but you did it! Thanks!!!
- Patrick2788Silver ContributorYou're welcome! Glad it worked.