Hello- I am trying to subtract the most recent # of vaccines on hand from the sum of the total vaccines delivered- any suggestions?
Tried this but it did not work: =(SUM([If you got a shipment, how many doses were in it?]2:[If you got a shipment, how many doses were in it?]61)) - (INDEX([# of vaccine doses on hand today (#s only)]2:[# of vaccine doses on hand today (#s only)]61, MATCH(MAX(COLLECT([Today's Date (Fill daily)]2:[Today's Date (Fill daily)]61, [# of vaccine doses on hand today (#s only)]2:[# of vaccine doses on hand today (#s only)]61, @cell <> "")), 0)))
