I have a Pivot Table below where column 1 has the value 'a' for my 3 rows of
data. How can I do a vlookup on column 1 with the value 'a' and column 2
with the value 'e' and return my total of 3?

Count of 3
1 2 Total
a d 2
e 3
n 1
a Total 6
Grand Total 6