I'm in QA and am trying to create a table for tracking build verification reports based on 3 criteria:
accept entries within the past week)
-Conditional (for this example, I will count how many verification passed)
-Branch (the branch the build is based off of, for this example, branches will be “Primary” and “Tertiary”)
Through some help here, I found that the =countifs function works best, and I was able to count how many builds passed
based upon the following formula:
=COUNTIFS('BVT History'!B2:B1000, ">="&TODAY()-6,'BVT History'!C2:C1000,"Pass")
Where the ‘B’ range is dates, and the ‘C’ range is conditionals.
I’m almost done with this table; however, needed
to enter functionality where the user types in the name of the branch they want results for in cell “C2” and the range is
A2:A100 on the BVT History workbook. So I figured the following formula would work:
=COUNTIFS('BVT History'!B2:B1000, ">="&TODAY()-6,'BVT History'!C2:C1000,"Pass", 'BVT
However, it doesn’t. Do you know what I’m doing wrong here? I tried hard
coding in conditionals as well, but it seems like the countifs function breaks when applying a third criteria field.