Hi,

Am Thu, 23 Jul 2015 23:22:13 +0100 schrieb Excel Dumbo:

File link is http://speedy.sh/453Sm/Sum-If-Query.xlsx

I named the range in "Oracle Data" with a dynamic name that you always
calculate with the exact range. I also changed the formulas in the range
C5:AB10.
Change the other formulas similiar and test the behaviour of the
workbook.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional