Macros to Add Active Cells in a Pivot Table

[kevyee]

Hi,

I'm looking for a formula that would help add the values of cells that a pivot table filter yields.

For example:
I have a large amount of data and I search for target word "Arginine" in the pivot table.
Arginine values would appear in cells F1, F8, F100.

Is there a convenient Macro that can add all the "searched" values?

Thanks in advance! Any help would be greatly appreciated.