Thanks. I have tested the SUMIF and it works. However is there a way to have the value in the middle of the SUMIF reference a file? Rather than just entering one phone number. See my example below:
Can that phonen number above be substituted with a bunch of numbers. I can achieve it with several SUMIFs with different numbers, see example below:
This gives me 3 results which I can subtotal. I would rather it be easier to run, maybe an add-in or something with a macro and vb code behind it? I just don't know how to achieve it.
Cheers
Bookmarks