Forum Discussion
Excel Formula
Hello I am needing help with calculating a formula that will tell me if some is a resident, and over the age of 65 and has received 2 bivalent boosters (either moderna Bivalent or Pfixer bivalent) ...
In a cell in row 2:
=AND(E2>65, G2="Resident", SUM(COUNTIF(W2:AB2, {"Moderna", "Pfizer Bivalent Booster"}))=2)
If you don't want to include the first shot, use Y2:AB2 instead of W2:AB2.
Fill down.
- okay this might make it more complicated, but essentially I am trying to calculate if the person is over 65 and its been 4 months since their first bivalent booster. trying to determine who is "up to date"
Since the first bivalent booster or the last?
- since first bivalent.
