Forum Discussion

tylernol's avatar
tylernol
Copper Contributor
Mar 13, 2023

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. ...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 13, 2023

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))
tylernol's avatar
tylernol
Copper Contributor
Mar 13, 2023
I don't why it wasn't working for me originally, but you did it! Thanks!!!
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Mar 13, 2023
    You're welcome! Glad it worked.

Resources