Link COUNTIFS formula from old workbook to new

[Ofsthun01]

Morning all. Relative Excel novice, so I just don't know where to start with figuring this out.

I have an Excel file that's getting too large and need to make a new one for the year it seems. But I have a COUNTIFS formula in column Q that counts the number a times a street address and city appear together (=COUNTIFS($F:$F,@$F:$F,$G:$G,@$G:$G)) so I know how many times an address shows up my report.

How can I reference this formula from my old workbook, so I keep the running total of every time an address has shown up, while simultaneously counting each time it shows up going forward on the new workbook?

Thanks!

 

[PeteWright]

Hmm...
All I can do is guess.

Could you upload or paste (with XL2BB) some of your data?
You may of course change the values for data privacy reasons.
If I know your workbook/sheet structure then I could play around a little bit and see if anything could be done.