I have a large table with the number of patient encounters in Column A, and
a listing of procedure codes in Columns B:D. Unique procedure codes may
appear in multiple rows, but will only appear once in each row. For
example, in Row 1, I may have 10 encounters with Procedure Codes P1, P2, and
P3 in columns B:D, respectively. In Row 2, may show 20 encounters with
Procedure Codes P1, and P4 in Columns B:C (Column D is blank). I am trying
to build a formula that will add the number of encounters (from Column A)
for each row that contains P1. Ultimately, I want to be able to get the
totals (summing Column A values), for all Procedures P1, P2, P3, Pn.
Greatly appreciate any help you can offer.